Move database from ipage to bluehost

Today I have to move wordpress blog from ipad web host to bluehost. Everything work well except one thing :

database

Database error and after examine error message I found a way to overcome that problem.

1. Open sql  from ipage exported file (created by phpmyadmin)

2. Open with editor (notepad or wordpad) and look for these lines :

— Database: `101_xmas`

 CREATE DATABASE `101_xmas` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
 USE `101_xmas`;

Yes, italic things I set must be ignored by bluehost and to accomplish that thing you can add — in front of the lines.

save the file and reupload through phpmyadmin.

This time I see :

Import has been successfully finished, 30758 queries executed. (custsql-ipg09.eigbox.net.sql)

Good, I can continue to other work 🙂

 

Spread hosting service with dns and cpanel

My friend ask me about possibility for spread service and reduce the cost of hosting. He want to teach blog  with more than 12 person of his photography class. He only have one domain and hosting account with 50 MB space 🙂

I understand his situation and give straight solution : use free blog service.

Yes, he can use blogspot, wordpress.com or blogetery or posterous or tumblr.

But, his question lead me to new experiment too.

I want to try to test this :

  • 1 sub domain goes to blogspot
  • 1 sub domain goes to blogetery
  • 1 sub domain goes to soup.io
  • 1 sub domain goes to tumblr

All sub domain use hostingformula.net as main domain and cpanel that bluehost  provide.

At the end of this experiment I will have these :

  • http://blogspot.hostingformula.net -> for blogspot service
  • http://blogetery.hostingformula.net -> for blogetery service
  • http://soup.hostingformula.net -> for soup.io service
  • http://tumblr.hostingformula.net -> for tumblr service

Lets get start!

Subdomain experiment with Blogspot

Read how to set subdomain of hostingformula.net using blogspot service.

Subdomain experiment with Blogetery

Read how to set subdomain of hostingformula.net using blogetery service.

Subdomain experiment with Soup.io

Read how to set subdomain of hostingformula.net using soup.io service.

How to add TXT Record on BlueHost for Activate Google Apps

In recent domain purchase on Godaddy I have disable automatic domain renewal (goes to manual and force Godaddy to send an email about expire domain) and change dns record to bluehost.

Due to that change I force myself to choose 1st option of activate google apps.

I’ll show you how to add TXT Record on bluehost hosting for activate google apps.

1. Sign up for google apps

2. Activate google apps for domain

google apps provide 4 ways :

  1. Add a DNS record to your domain’s configuration
  2. Add a meta tag to your site’s home page
  3. Upload an HTML file to your server
  4. Link to your google analytics account

I choose number 1.

Add a DNS record to bluehost domain’s configuration

Choose other from ‘select your domain registrar or provider’ option.

copy and paste TXT record to notepad

Login to bluehost cpanel

Find ‘advanced dns zone editor’ .

click the icon

Select a domain

Add a record

  • change ‘google’  (from the picture) to yourdomain.xxx (xxx is your domain extension)
  • Let TTL as is
  • Choose TXT  Type
  • Paste TXT record that you have from google

click  ‘Add record‘ button.

You’ll see summary of your domain dns configuration.

Click “Delete” for existing TXT record (optional)

3. Verify domain ownership

Back to google apps page. Click Verify button to start verify the TXT record modification.

You’ll see this page if you do right job.

You can continue to activate email service and others from your google apps panel.

See you on other post and stay health!

CPU Throttle and Cache

Almost 20 host successfully move to bluehost while I left others in other web hosting for internet marketing purpose.

I just wnt to say that I’m impressed with cpu throttle technology that bluehost use in their shared hosting.

As you can see in the picture I got ‘throttle’ every hour but I still can get my site accessed during that period which is cool bro.

I also implement Cache Solution for WordPress that reduce throttle time to almost 30% off.

Kudos to cpu throttle technology and wordpress cache!

Install IonCube Loader on Cpanel based Web Hosting

Yes, another move to new host bring new home work and I love to solve it 🙂

Ioncube loader need to enable at this host and I’m lucky the process it self not difficult to accomplish.

Here step by step guide on how to enable ioncube loader on bluehost web hosting :

Check Current PHP status

Create new php file, for example info.php and put this line :

<?php

phpinfo();

?>

save the file and access it from web browser :

http://your.url/info.php

Scroll down and pay attention to this picture

As you see no support for IonCube by default bluehost account.

More

Step by step setting permanent redirect 301 with cpanel

Migration to new web hosting almost complete. One step need to take at the moment is :

Announce new url while maintaining traffic

The solution is simple, just enable permanent redirection 301.

Step by step guide on activate permanent redirection 301 with cpanel hosting.

Cpanel login

Make sure to open port 2082

Cpanel Domains Menu

Click Redirects icon as shown in the picture.

Redirection menu

  1. Choose Permanent (301) from type.
  2. Choose old domain that will redirect
  3. Enter new address in redirects to input box.

Check Wild Card Redirect.

Click Add

More

How to monitor my website or blog uptime status

I’m apologize for hostingformula.info reader as you may face some downtime issue. Actually one of my best friend told me about this issue when he want to access posting about drupal and xampp.

He also suggest me to use monitoring service to let me know if this blog is down.

I agree and I choose free monitoring service from wasitup.

The interface is simple and easy to understand. Just enter the url and email address as shown in the picture.

my expriment with hostingformula.info give me this

More