How to migrate databases from MariaDB 5 to MariaDB 10

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:

  1. 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.
    1.png
  2. Click the Install button.
    2.png
  3. 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:

  1. Sign in to the MariaDB 5 server.
    3.png
  2. Go directly to the Export tab.
  3. Select an export method and desired export format. Click Go to export.
    4.png
  4. Click on the door icon to sign out of the MariaDB 5 server.
    5.png

Import Databases into MariaDB 10

Stay in phpMyAdmin to manage and complete the migration on MariaDB 10:

  1. Sign in to the MariaDB 10 server.
    6.png
  2. Go to the Import tab.
  3. Click Choose File to select the previously exported file that contains the databases from MariaDB 5.
    7.png
  4. Click Go to import and complete the migration process.
Purpose
Environment
Resolution
Install MariaDB 10
Export Databases from MariaDB 5
Import Databases into MariaDB 10