How to backup the MySQL database using phpMyAdmin

This guide will cover the basics in backing up the MySQL database using phpMyAdmin.

This guide assumes the following

That the Web Station and MySQL service are enabled on the Synology Server
That you are familiar with the Synology Management menu, and have experience with manipulating the security permissions of the Synology Server
That phpMyAdmin is installed on the Synology Server

Backing up the MySQL Database


Step 1: Begin by logging into the phpMyAdmin interface, via http://synologyserver/phpmyadmin Afterwards, click on the exports link
Step 2: Here is the export menu, here is where options can be set for the MySQL database backup a) Select which database that needs to be backed up b) Select what type of file should the resulting backup file should be. It is recommended to use SQL c-f) These are advanced options which you can use in the SQL file, please refer to the phpMyAdmin documentation or Wiki for further information g) Enable save as file h) Select the file type that the export file should be i) Press Go and the Synology server will begin to process the export request. After the initial processing, the web-browser will present a save file prompt, please save the file somewhere safe. This will be your backup file of your database.

Begin by logging into the phpMyAdmin interface, via http://synologyserver/phpmyadmin
Afterwards, click on the exports link

Here is the export menu, here is where options can be set for the MySQL database backup

a) Select which database that needs to be backed up
b) Select what type of file should the resulting backup file should be.
- It is recommended to use SQL
c-f) These are advanced options which you can use in the SQL file, please refer to the phpMyAdmin documentation or Wiki for further information
g) Enable save as file
h) Select the file type that the export file should be
i) Press Go and the Synology server will begin to process the export request. After the initial processing, the web-browser will present a save file prompt, please save the file somewhere safe. This will be your backup file of your database.