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`
