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.
You should now be able to log into your wp-admin panel and successfully upgrade to the latest version of WordPress!