Problem
Had trouble updating the underlying GoDaddy MySQL to version 5.0 required by WordPress 3.
Solution
Create a new WordPress site on same hosting server and migrate the data
Steps
1. Export content to XML in WordPress admin console
2. Create a new WordPress blog (which also creates a new MySQL instance)
3. Import the XML content into the new WordPress blog
4. If using a custom them, copy the contents of the theme folder in WordPress to the new WordPress site
5. On New WordPress site admin console, change path to existing WordPress URL
6. On Old WordPress site admin console, change path to a name like blog_old for the WordPress URL
7. Via a FTP client, rename the production blog folder to blog_old
8. Via a FTP client, rename the new blog directory to the production folder name
