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

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