How to migrate databases from MariaDB 5 to MariaDB 10
Last updated:Apr 14, 2021
How to migrate databases from MariaDB 5 to MariaDB 10
Purpose
If you wish to switch from MariaDB 5 to MariaDB 10, you may want to migrate the databases. This tutorial will guide you through the MariaDB database migration process.
Environment
This article assumes that you have done the following tasks:
- Signed in to your Synology NAS using an account belonging to the administrators group.
- Installed the following packages on your Synology NAS:
- phpMyAdmin
- MariaDB 5
Resolution
Install MariaDB 10
Install the MariaDB 10 package on your Synology NAS:
- Go to Package Center > All Packages. Scroll to the Third-party packages section to look for the MariaDB 10 package or simply type "MariaDB" into the search bar and press Enter.
- Click the Install button.
- Follow the on-screen instructions to install the package.
Export Databases from MariaDB 5
Launch phpMyAdmin to manage and migrate the databases on MariaDB 5:
- Sign in to the MariaDB 5 server.
- Go directly to the Export tab.
- Select an export method and desired export format. Click Go to export.
- Click on the door icon to sign out of the MariaDB 5 server.
Import Databases into MariaDB 10
Stay in phpMyAdmin to manage and complete the migration on MariaDB 10:
- Sign in to the MariaDB 10 server.
- Go to the Import tab.
- Click Choose File to select the previously exported file that contains the databases from MariaDB 5.
- Click Go to import and complete the migration process.