How to manually back up or restore client MySQL database in Plesk for Windows

Question

How to manually back up or restore client MySQL database in Plesk for Windows?

Answer

1. Connect to Plesk server via RDP;

2. Open command prompt as Administrator
3. Back up client database:

   C:> "%plesk_dir%"MySQLbinmysqldump -uadmin -p -P3306 client_base > client_base.dump

   where:
   3306 - port for MySQL server;
   client_base  - database name; 
   client_base.dump  - name of database backup.

   Note: MySQL admin password will be asked during the commands execution. In case it is not known, it can be safely changed at Tools & Settings > Database Servers > localhost (default for MySQL) on port 3306.

4. Restore the database:

   C:> "%plesk_dir%"MySQLbinmysql -uadmin -p -P3306 client_base < client_base.dump

WARNING: just copying folder with database name from
'%plesk_dir%DatabasesMySQLdata' directory is not correct way of backing up.