Creating a manual database backup
- Plesk Onyx
plesk db dump <database_name> > C:/path/to/<dump_name>.sql
Plesk 12.5 and previous releases
Note: MySQL admin password is required for this operation.
“%plesk_dir%”\Mysql\bin\mysqldump.exe -uadmin -p -P8306 <database_name> > C:/path/to/<dump_name>.sql
Example
The following command for Plesk Onyx creates a database dump of the Plesk ‘psa’ database on C:\ drive:
- plesk db dump psa > C:\psa_dump.sql
Restoring a database from a manual database backup
- Plesk Onyx
plesk db < C:/path/to/<dump_name>.sql
Plesk 12.5 and previous releases
Note: MySQL admin password is required for this operation.
“%plesk_dir%\Mysql\bin\mysql.exe” -uadmin -p -P8306 psa < C:\<dump_name>.sql
Example
The following command for Plesk Onyx restores the Plesk ‘psa’ database from the database dump psa_dump.sql located on C:\ drive:
plesk db < C:\psa_dump.sql