Brief Notes on Database Upgrades

No Comments
Administrativa, Technology, Wordpress

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.
* Save/Upload.

Now to update the other blogs on here…

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>