Transferring WordPress Database
]
Answer #2
Hello,
I am happy to hear you were able to find a solution that worked!
If you don’t mind, can you enlighten the rest of our users with the solution you used so that they can benefit from your experience?
Happy Hosting!
]
Answer #3
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.
Answer #4
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.
Answer this Question
You must be Logged In to post an Answer.
Not a member yet? Sign Up Now »
Answer #1
Figured out on my own. Thanks!