Take database backup on a Plesk server.

[Total: 6    Average: 5/5]

If you want to take database backup for your website then you can use below steps:

Login to server through SSH and use command :

# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` DATABASE_NAME > FILE_NAME.sql 

Note : 1) DATABASE_NAME use your original database name.

Also, if you have database backup in .sql dump file and you want to restore it then you can use the below command :

 # mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` DATABASE_NAME < FILE_NAME.sql 

That’s it.