How To Move Your WordPress Database to a New Blog Host

How To Move Your WordPress Database to a New Blog Host

by: Carmela 

So you’ve decided to move Wour WordPress database to a new blog site host like Blogger and wanted to create a free blog, only to find out later that you can still find your former URL all over the ‘Net. How do you change paths? 

Enter WP Migrate DB. What this plugin does is perform a find/replace function on your URLs and file paths and exports your database as an SQL file. It also takes into account serialized data and updates the string length values.

Here’s how to do it:

1.       Install the plugin.

Click HERE to download WP migrate DB.

There you will find the instructions for installing and activating the plugin.

2.       Activate the plugin.

3.       Export your database. 

Go to Tools >> WP Migrate DB

You will see 4 fields here:  

a)      current address

b)       new address

c)       current path

d)       new file path. 

The first one is for your current URL. The second is the path from your server.
If you aren’t sure what it is, you can create a PHP info file with <?php phpinfo(); ?> in the source, save, and then load it up on your hosting directory and access it (site.com/phpinfo.php). Scroll down to SCRIPT_FILENAME to view your server path.

Enter the information for the new site, then click on ‘export database’. It will save your SQL file.

4.       Import Your Database

Once you’re in your new host web site, go to your phpMyAdmin, access the database where you stored your WordPress data in or where you will import it to, then go to “Import” and choose the SQL file that you downloaded.

And there you go!

This is for just the database. You still have to reset your permalinks rewrites through .htaccess by wiping the .htaccess file, turning permalinks back to default, and then back to your preferred setting. Also, you will have to perform some manual updates if your root is changing and if you have any CSS that calls to a full path from your old host.

I hope you found this tutorial helpful. Good luck with your new host web site!