The new version of WordPress recently came out and it required MySQL5 to be in use however I had MySQL4 installed. Upgrading should be easy, but this proved not to be the case.
After much research I found this solution online. The source of my happiness is here.
I have copied the critical contents here for purposes of archival should the original be removed. This solution worked and took around 15 minutes to complete.
- Backup your database Wp-db-backup plugin
- Run the backup once it is installed. Check all the boxes to get all the data.
- extract the .gz file I use 7-zip open source for this
- create a new database on your host 5.0
- log into the new database
- import function
- browse and select uncompressed file
- Select the ascii option for character set usually utf8 will be selected
- click go
- change the wp-config.php file to point to the new 5.0 database
- upload the config file to your blog
- download and install the search and replace plugin
- activate the plugin You will find it under the “Manage” Tab
- search for ?? replace with “space character”
NOW PLEASE PAY ATTENTION!
The “Search and Replace” plugin MUST be updated. Seriously. Check and Check again.
After checking, CHECK it is active. Yes, Seriously, this drove me slightly mad.
I chose to Search and Replace only in Blog Posts. I don’t know if this is correct or not, but since you’re here I guess it worked. This replace is required as the Posts have “??” symbols throughout them after import.