PureNews is an amazingly sleek and powerful news theme with unlimited color variations.

View full feature list Check out the live demo Buy this theme today

How to Upgrade MySQL in GoDaddy

Posted by on 6th Jan 2011 | 13 comments

My celebrity fashion blog hosted on GoDaddy was still using WordPress 2.8.3, so I decided to click the handy dandy “Update to 3.0.4″ button to upgrade automatically. I was all excited as it was “unpacking the update” until I got a message that the Installation Failed:

The update cannot be installed because WordPress 3.0.4 requires MySQL version 4.1.2 or higher. You are running version 4.0.30.

Great. Not being a highly techie person, I had no idea how to upgrade my MySQL database, but I figured it, and thought I’d share the steps for anyone else caught in the same predicament:

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.

You should now be able to log into your wp-admin panel and successfully upgrade to the latest version of WordPress!

13 comments - Leave a reply