How do I transfer my wordpress blog from one host to another?

Backup your Wordpress database using phpMyAdmin

Please note that phpMyAdmin is a tool written in PHP to handle the administration of MySQL over the web. Databases must be created in cPanel, but phpMyAdmin can drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, and export data into various formats.

Sorry, but we do not offer support for using phpMyAdmin. You can find support at phpmyadmin.net.

Note 1: PHPMyAdmin will NOT  allow you to create databases directly on it. You can only create MySQL Databases.

Once all those settings are selected you simply click on ’save as file’, this will download a file named wordpress.sql to your desktop. And that is that. You have successfully backed up your database.

If you don’t have PHPMyAdmin installed on your hosting account, you can use mySQLDump from a SSH terminal.

Download/Upload all your Wordpress files using FTP.

You will need to download ALL your files from your old host and upload them to your new host.  This includes files from your themes folder and plugins folder. Make sure you also download any folders which were referenced outside of your blog folder. For example, I use a separate folder called ‘images’ which is located outside of ‘blog’. If I didn’t copy and upload this folder to my new host I would have a lot of broken links to images within my blog post. This is not a pretty sight.

The FTP client I use is Filezilla. By default, Filezilla does not display your .htaccess file, probably for security reasons but I’m not too sure. To ensure that your .htaccess file is included in your download you must click on ‘View’ and then enable ‘Show Hidden Files’. If you neglect to upload your .htaccess file then your permalinks will get screwed up. That is of course if you are using permalinks.

Please note that you should not take this opportunity to update to a newer version of Wordpress. Your database may not sync’ as a result. Complete your migration before you consider upgrading.

Edit wp-config.php and create a new Wordpress database.

Okay, so we are nearly there. You must now edit wp-config.php to include the database settings of your new database.

Once you have edited the file with your new database settings, upload it to the root of your blog folder.

So now everything is set, expect that your new database does not contain any database tables.

Import your Wordpress blog to your new Database.

You can use either phpMyAdmin to import your database or you can use BigDump.  BigDump is the preferred option if you have a large database (10mbs or more). There is a step by step guide on how to use BigDump on their website.

Once you have logged in, you can choose between two methods to complete the import. You can click on ‘SQL’ and run a query or you can use the ‘Import’ link to upload your wordpress.sql file into your database. I recommend using the former as the query can take some time and can sometimes crash your browser. Using the import feature seems to be a lot less strenuous on the browser.