How to BACKUP MySQL database
1. Go to Plesk control panel.
2. Click Databases in right side panel.
3. Click phpMyAdmin
4. Select the database you would like to backup from the left navigation tree.
5. Click the Export tab.
6. Choose the Quick export method if you want to export all the tables. Or choose Custom method to backup any particular set of tables with custom options.
7. Click Go and you will get a pop up to download the backup file to your local machine.
How to RESTORE MySQL database
1. Go to phpMyAdmin for the database you want to restore from plesk control panel.
2. Choose the database you want to restore from the left navigation tree in phpMyAdmin.
3. The phpMyAdmin script that restores your database does not drop the tables first. So you may delete all the existing tables in the database before restore. Click the Check All check box.
Click the With selected: drop down menu and choose Drop.
4. Confirm by clicking Yes.
5. Now Click the Import tab.
6. Click the Choose File button to browse for the MySQL backup.
7. You can use the default options and Click Go.