- Plesk for Windows
How to manually back up client MySQL database in Plesk for Windows?
Connect to Plesk server via RDP;
- Open command prompt as Administrator
- Back up client database:
C:\> "%plesk_dir%"MySQL\bin\mysqldump -uadmin -p -P3306 client_base > client_base.dump
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.
Restore the database:
C:\> "%plesk_dir%"MySQL\bin\mysql -uadmin -p -P3306 client_base < client_base.dump
WARNING: just copying folder with database name from
'%plesk_dir%Databases\MySQL\data\' directory is not correct way of backing up.