Built For Designers & Developers

Transferring WordPress Database

Hello, I am moving from Hostgator to your shared cloud hosting. Please note I didn't switch my nameservers yet as I want to preview everything and make sure things work. Here is what I did exactly: 1....

4 Answers In: Databases By: ubound [2 ]

Most definitely John!

First of all since database itself doesn\’t hold any data regarding database username and password it will work without modifying wp-config.php so you can simply make a fresh install of WordPress with new database and user name and then go to PHPMyAdmin and import your old database (the one you carried over from your old host). It will connect anyway and you don\’t have to modify anything.

Second, when you are previewing WordPress on IP you may have several issues like I did:

– when trying to sign into dashboard you are redirected to your old host (if site is still there)

– having 404s instead of content

To fix this you should go to PHPMyAdmin once again and enter your preview URL instead of site URL and WordPress URL. This is found in wp-options.

Instead of http://www.yoursite.com

you should enter your IP and username, something like

http://1111.2222.3333.4444/~yourusername/

You should edit both – site URL and WordPress URL. This will allow you to preview site and use dashboard.

In case you created different WordPress admin username and password during installation, it won\’t work. What works is what you have now at your old host.

The most important thing is not to forget to revert back to your site\’s URL before switching name servers. It will display 404s again but once name servers resolve it will be ok.

If you do it this way there will be no downtime whatsoever during the transfer.

Most definitely John!

First of all since database itself doesn’t hold any data regarding database username and password it will work without modifying wp-config.php so you can simply make a fresh install of WordPress with new database and user name and then go to PHPMyAdmin and import your old database (the one you carried over from your old host). It will connect anyway and you don’t have to modify anything.

Second, when you are previewing WordPress on IP you may have several issues like I did:

– when trying to sign into dashboard you are redirected to your old host (if site is still there)

– having 404s instead of content

To fix this you should go to PHPMyAdmin once again and enter your preview URL instead of site URL and WordPress URL. This is found in wp-options.

Instead of http://www.yoursite.com

you should enter your IP and username, something like

http://1111.2222.3333.4444/~yourusername/

You should edit both – site URL and WordPress URL. This will allow you to preview site and use dashboard.

In case you created different WordPress admin username and password during installation, it won’t work. What works is what you have now at your old host.

The most important thing is not to forget to revert back to your site’s URL before switching name servers. It will display 404s again but once name servers resolve it will be ok.

If you do it this way there will be no downtime whatsoever during the transfer.

Figured out on my own. Thanks!