How do you migrate your database? MySQL version upgrade

1 Retrieve the database

2 Create a new database

3 Assign MySQL users

4 Import database

5 Modify the configuration of your application/website

Retrieve the database

First you need to retrieve the data from your MySQL 5.7 database.

To do this

Go to the former Netim Direct interface.
Go to the Hosting services menu, then Shared Hosting Management.
Then select the hosting, and on the right-hand side, click on the Services management drop-down menu then Databases

A new window will open listing all the databases connected to this hosting. You can now check the version of each database by clicking on the cogwheel on the right.

The details of this database are displayed here. You will find the version (5.7 or 8.0) as well as the address of the local and remote server, a PHPMyAdmin connection button and the list of users.

Important ⚠️

You will need to make a note of each user assigned to this database before assigning them to the new database we are going to create.

Once you have your list of users :

You must connect to PHPMyAdmin by clicking on the button and using one of the users.
After logging in to PHPMyAdmin you will find a list of databases on the left. Please only click on the database we are working on. Then click on the Export button in the top menu to retrieve the data. All that’s left to do is click on the Export button and wait for the browser to prompt you to save the file in .sql format.

Once this step has been completed, all that’s left to do is repeat the procedure for all the other MySQL 5.7 databases.

Create a new database

Important ⚠️

If your hosting is limited to a single database, you will need to delete the previous one.

This step will let your application or site non-functional because the MySQL connection will no longer be possible.

However, it is important to check that the .sql file obtained for your database(s) is not empty and contains data.

If the file appears to be OK, you can now delete the database concerned via Netim Direct in the Databases menu and the Add tab.

It is important to name the database with the same name as the old one to save you from having to change a parameter in the following sections.

Assign MySQL users

Once the database has been created, you can now assign the user(s) to it.

In the Databases menu, click on the cogwheel in front of the database in question.
Then, in the Users section, switch the Assignment button to On.

Import database

Still in the same menu, click on the PHPMyAdmin button and enter the user’s credentials.
Then click on Import in the top menu.
Click Browse to select the .sql file exported from the old database. Leave all the parameters as default and then click on the Import button.

Wait for the process to finish and your database will finally be migrated to a more recent MySQL version.

Modify the configuration of your application/website

Important ⚠️

As the MySQL server has changed address, you will need to change the configuration of your website so that it connects to the correct server.

The address of the new server can be found on Netim Direct by clicking on the cogwheel in front of the database.

Here is a list of examples of files to modify depending on the CMS used:

WordPress: public_www/wpconfig.php
PrestaShop: public_www/app/config/parameters.php
Joomla: public_www/configuration.php