How to Upgrade MySQL in GoDaddy

By Kim Rowley | WordPress

Jan 06

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!

Follow

About the Author

Comments are closed