Upgrade MySQL in GoDaddy

Here is a step by step guide on how to upgrade your MySQL in GoDaddy. Some users have been having trouble with this, so we wanted to make it as easy as possible.

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.