This blog is so old that the current version of WordPress wouldn’t even install on the version of MySQL that the blog was created using.
It took a bit of figuring out, but this is how I dealt with the situation. H/T Blogging Tips. This is mostly for my own future benefit but someone else may find this set of steps useful as well.
1. Backup Your Current Database
* Log into GoDaddy.com
* Go to My Account > Web Hosting
* Click on “Launch” Control Center under “My Accounts”
* In the Hosting Dashboard, Click on Databases > MySQL
* Find the Database Name you want to back up
* Click on Pencil Icon under “Action”
* Click “Backup” – This can take up to 2 hours.
2. Create a New Database
* You can start this while waiting for backup.
* Go back to “MySQL” and “Create Database”
* I recommend naming the description the same with a “2″ after it
* Make sure MySQL Version is clicked to 5.0 (default)
* This will now be “Pending Setup”
* You have time to go grab a latte or sometimes two or three.
3. Restore Backed-Up Database to New Database
* Refresh MySQL Database List
* If your new database is Setup, click Pencil Icon
* Click “Restore” Icon
* Click Old Database File Name
* Click “Restore”
* Click “OK” on pop-up confirming Database Restore
* This will now be “Pending Restore”
* Grab another latte (or use the restroom after the last ones)
4. Update wp-config.php file
* Use an FTP software – I use FileZilla (it’s free)
* Find the wp-config.php (you may want to copy/save just in case)
* View/Edit (right click in Filezilla)
* Change properties in file with the new MySQL database name, MySQL user name (usually the same), MySQL password and MySQL host name.
* Note that GoDaddy’s MySQL host name is never “localhost”, but an actual URL.
Now to update the other blogs on here…