How to Upgrade MySQL in GoDaddy

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!

About the Author

dotCOMreport - January 6, 2011

This is really great for the non-techies! I know I've found it handy. Thanks.
My recent post Lessons to Learn from the Groupon-Scoopon Issue

dotCOMreport - January 6, 2011

This is really great for the non-techies! I know I've found it handy. Thanks.
My recent post Lessons to Learn from the Groupon-Scoopon Issue

dotCOMreport - January 6, 2011

This is really great for the non-techies! I know I've found it handy. Thanks.
My recent post Lessons to Learn from the Groupon-Scoopon Issue

dotCOMreport - January 6, 2011

This is really great for the non-techies! I know I've found it handy. Thanks.
My recent post Lessons to Learn from the Groupon-Scoopon Issue

dotCOMreport - January 6, 2011

This is really great for the non-techies! I know I've found it handy. Thanks.
My recent post Lessons to Learn from the Groupon-Scoopon Issue

dotCOMreport - January 6, 2011

This is really great for the non-techies! I know I've found it handy. Thanks.
My recent post Lessons to Learn from the Groupon-Scoopon Issue

Andy - January 7, 2011

Excellent walkthrough. I've bookmarked it for future reference. Cheers!
My recent post Is Spam Off The Menu

Sucuri Sucuri - January 8, 2011

An excellent write up Kim, and welcome to the BloggingTips team!

sparky - January 10, 2011

Thanks for this. I've been looking for a tutorial like this so this is perfect timing.
My recent post Hello world!

Eng / Mahmoud zezo - January 11, 2011

wow , good post. Really it's very helpful for me
thanks
My recent post Turbo-Decoder

Frank McAllister - January 18, 2011

Excellent tips Kim! I follow your working in my pajamas blog and I would like to thank you for this useful tip
for go daddy. I have been using Go Daddy for several years now and this article helped my out a great deal!
Anyways keep up the great work and keep these post's coming!
http://www.hakspeak.com @ http://www.moddingmadness.com
My recent post AMD Phenom II X4 965 Black Edition Deneb 34GHz

TheChurning - March 22, 2011

This was soooo helpful. Thank you thank you thank you!
My recent post Parking drama in South Philly

Eric - May 14, 2011

Thank you so much. I just used your information to successfully update my sql database. You steps were laid our very clearly. thanks again

Comments are closed