Plesk Mysql database backup and restoration


The following command is used to generate and restore the database hosted on the Plesk Linux Server from the shell.

To generate the mysql database backup refer the command

mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` database_name > database_backup_file.sql

To restore the database backup file in the respective database refer to the following command from the shell.

mysql -uadmin -p`cat /etc/psa/.psa.shadow` database_name < database_backup_file.sql

To access the mysql prompt on the Plesk Linux Server refer the command

mysql -uadmin -p`cat /etc/psa/.psa.shadow`

About Anant 373 Articles
Senior technical writer