Converting a MySQL 5.5 database to 5.7

This relates to our legacy Minimus\Medius\Maximus hosting plans only.

The following steps would need to be carried out if you see the below on WordPress:

Outdated SQL server

  The SQL server is a required piece of software for the database WordPress uses
  to store all your site’s content and settings.

  For optimal performance and security reasons, we recommend running MySQL version
  5.6 or higher. Contact your web hosting company to correct this.

This article will show how to convert your MySQL 5.5 database to a MySQL 5.7 database in https://cp.blacknight.com

Open your database by going to More Services > Databases > database name > Browse database manager link

This will open phpMyAdmin. You can see the current server version on the right of the screen.

Click on the name of the database on the left of the screen to display the contents of the database, and give more options.

Click on Export at the top.

Leave the default options and click Go.

Depending on your browser, it will either ask you where to save the file, or put it in your default download location. The file will be your database name with .sql at the end.

Next you'll need to create a new database in More Services > Databases > Add New Database.

Select MySQL from the menu and click Next.

Give it a suitable Name, Username, and Password. Click Next, and then Finish.

Also take note of the Internal Hostname as it will be needed when editing your sites database configuration string.

Open your new database by going to More Services > Databases >  new database name > Browse database manager link

Your new database will have a server version of 5.7.

Click on the name of the database on the left again, but this time click on Import on the top menu.

Click on Choose File, select your .sql file, and then click on Go.

You will now have a MySQL 5.7 database with your old data in it. You'll need to update the database connection string details in the configuration file of your website.