Recently I had to upgrade a website on WordPress because the version of WordPress that I wanted to upgrade to needed a mySQL database running version 5.x to work correctly and the website had previously been running 4.x. What you’ll see is this issue happening on platforms that run off of a mySQL database like WordPress, Drupal, Joomla and others currently and in the near future as new versions come out that are compatible with mySQL 5.x or greater. So if you are running a website that works on these platforms with mySQL 4.x then you may want to think about upgrading your database. I’ve put together some steps to help you do this seamlessly.
Step 1: Backup your existing mySQL 4.x database that runs your website currently.
Step 2: Create a new mySQL 5.x database for your website and give it a new and different name.
Step 3: Click the “Restore” option or run the command line to restore the backup you took of the mySQL 4.x database and restore it to the newly created mySQL 5.x database.
Depending on what platform you run your website on currently you may need to do some additional things to get the website back up and running but you should be able to figure this out from the prompts and messages that the system displays. So as you can see it’s not a huge or involved process to get your mySQL database upgraded.