Introduction
MariaDB 10.x and MySQL 8.x databases have structural differences that prevent a database from one from being imported into the other. For the database to be imported into the new server, it must be exported using an older format. This article provides the steps needed to export a MariaDB 10.x or MySQL 8.x database in the MySQL 4.0 format, which can be imported on both MariaDB 10.x and MySQL 8.x servers.
Procedure
- Log into the user's cPanel account on the source server.
- Open the "phpMyAdmin" interface.
- Select the database.
- Click the "Export" tab.
- In the "Export Method" section, select the "Custom - display all possible options" option.
- Scroll down to the "Format-specific options:" section.
- Select "MYSQL40" from the "Database system or older MySQL server to maximize output compatibility with:" dropdown menu.
- Scroll to the bottom of the page.
- Click the "Export" button.
- Transfer the .sql file to the new server.
- Import the .sql file as you normally would.