MariaDB 10

MariaDB 10 is a community-developed fork of MySQL and is one of the most widely used open-source relational database management system (RDBMS). It is highly compatible with MySQL and allows users to effortlessly migrate databases from MySQL to MariaDB 10. With MariaDB 10, you can easily and efficiently read, update and manage your data.

Reset Settings

You can reset your MariaDB 10 database password or delete databases directly on the user interface.

To reset the password:

Click Reset MariaDB 10 Password. Note that this action will reset the user's root password to an empty one.

To delete databases:

Click Reset Database. Note that all data and settings of your MariaDB 10 databases will be permanently removed and cannot be recovered after they are deleted.

Modify Volume Settings

If there is more than one volume available on your Synology NAS device, you can specify in which volume you want to create and place the databases.

To change the location of the databases:

From the drop-down menu, choose the volume you want to store the databases. Click Apply for the changes to take effect.

Port Setting

You can modify the port number of MariaDB 10 directly on the user interface.

To set the port number:

Fill in the desired port number. Click Apply for the changes to take effect.

Back up and Restore

You can back up MariaDB 10 and restore it to a previous version via Hyper Backup.

To back up MariaDB 10:

1. Go to Hyper Backup > Create > Data backup task to create a backup task.
2. Follow the Backup Wizard, and choose MariaDB 10 when you are prompted to select applications to back up.
3. After the backup task is complete, all the MariaDB 10 databases will be backed up.

To restore MariaDB 10:

1. Go to Hyper Backup > Restore > Data to restore the desired backup task.
2. After the restore task is complete, the current settings and data of MariaDB 10 will be overwritten.