Here it is! Step by Step instructions for moving a WordPress blog to a new hosting provider. This is extremely helpful if you ever sell a blog, buy a blog, flip a blog, or just decide you don’t like your hosting provider and want to move all your sites to a new home!
Many thanks to Forest Parks who originally showed me the light!
- FTP to the site that you want to transfer. Copy everything in the wordpress wp-content folder to your desktop.
- Login to your Cpanel and go to PHP My Admin. On the left, click on the name of the database for your blog that your moving.
- Click on the Export tab within PHP MyAdmin. Export the database as SQL (should be the default) I normally leave the settings as they are. At the bottom make sure “Save as file” is checked and click Go. Save file to your desktop
- Change your DNS. Login to your domain management and set the nameservers to that of the new host. With GoDaddy propogation is normally done in 3 or 5 mins.
- Go to your the hosting provider and set up the hosting account. Login to cpanel and use Fantastico Deluxe to install a new version of wordpress (You can also install it manually if you need to)
- FTP to the new host. Copy your wp-content from your original site and overwrite the installed wp-content.
- Login to the new PHP My Admin. Find the new wordpress database (this was created when you installed WordPress on the new site) Open the wordpress database, select all the files inside and select the drop option. The database should now be empty.
- Finally, Import your saved database into the now empty database.
- (Optional) – Take a break – have a beer – you deserve it!
How To Find The Name of Your Database
- If you have trouble finding the correct name of the database that your WordPress blog is using… you can find it this way.
- FTP to your site.
- In the root directory of your web site there is a wp-config.php file.
- Open this file with a text editor. (be careful – editors like Windows Notepad may add hidden characters to your file) I use Notepad++ it’s free and won’t mess with your files.
Look for the following lines in your wp-config.php file
define('DB_NAME', 'myname_mydbname"'); // <-- The name of the database define('DB_USER', 'myname_myuser'); // Your MySQL username define('DB_PASSWORD', 'password'); // ...and password define('DB_HOST', 'localhost'); // you won't need to change this
The first line shows you the database name you need to work with.
And that’s it! Let me know if this has helped you in any way. Also visit Forest’s website and give him some thanks too!