How Do I Backup MySQL Databases?
Login to the Plesk Control Panel. Click on Home > Databases > database name Now click on DB Webadmin – this will pop up a new window. Make sure pop ups are not blocked. You should now be in PHPmyAdmin. Click on the database name on the left-hand side (usually the first line). The right-hand screen should update. At the top on the right hand screen, click on Export. Under ‘Structure’ we recommend you tick ‘Add Drop Table’. Under ‘Data’ , we recommend untick ‘Complete Inserts’ and untick ‘Extended Inserts’. Leave everything else as is. Then tick ‘Save as File’ and click Go.