As you can see from my previous post’s I’ve recently moved my WordPress Blog from www.cheapnames.co.uk to www.uk.godaddy.com , obviously I’d never done anything like this before and had a very large learning curve to figure out :
- How to backup the WordPress MySql Database from www.cheapnames.co.uk
- How to upload the migrated WordPress MySql Database to www.uk.godaddy.com
- How to make the migrated MySql Database work on my new web hosting
How to Backup your MySql Database using phpMyAdmin
First place I started was with google which after a bit of hunting down took me to this site
http://www.inmotionhosting.com/support/website/databases/export-database-using-phpmyadmin
Here you’ll find basic instructions for exporting your MySql Database and saving it to a location on your computer
How to upload the migrated WordPress MySql Database
The next step was importing the large MySql Database into GoDaddy’s phpMyAdmin, due to size limitations on importing into MySql I had to find a work around.
Files that are too large to be imported directly into MySql, can be “restored” to the database by uploading the desired file into the db_backups folder contained within your ftp folders on your GoDaddy webhosting, once in there you can then use it to restore over the WordPress Database that are listed, obviously before doing this you first need to install a fresh copy of WordPress using GoDaddy’s handy self-installer, once this is done just select the Database you’ve uploaded into the db_backups folder and use that to restore/overwrite the present Database (You won’t actually need to do this restore until you’ve got to the section on making the migrated MySql database work with your news migrated blog.
How to make the migrated MySql Database work on my new web hosting
Now this is the section that takes a bit of practice to get right, took me a few attempts, mainly due to me not reading through the whole thing properly, suggest you print a copy off and as you do each section mark it off with a highlighter, that way you know exactly where your upto and are unlikely to miss any steps like I did.
The sections on this website cover literally all types of migration you are likely to attempt, so find which suits you best and follow it carefully
http://codex.wordpress.org/Moving_WordPress
So once you’ve done all of the above you should hopefully now have a fully migrated working WordPress blog.
If anyone needs help with migrating feel free to contact me and I’ll endeavor to assist you as best I can.