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!
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
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
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
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
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
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
Excellent walkthrough. I've bookmarked it for future reference. Cheers!
My recent post Is Spam Off The Menu
An excellent write up Kim, and welcome to the BloggingTips team!
Thanks for this. I've been looking for a tutorial like this so this is perfect timing.
My recent post Hello world!
wow , good post. Really it's very helpful for me
thanks
My recent post Turbo-Decoder
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
This was soooo helpful. Thank you thank you thank you!
My recent post Parking drama in South Philly
Thank you so much. I just used your information to successfully update my sql database. You steps were laid our very clearly. thanks again