- Plesk for Windows
How to backup client MySQL database manually on Windows?
How to backup client MySQL database:
Connect to the server via RDP;
- Open Command Prompt as Administrator and execute the following command:
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.
To restore it on another server run the following command:
C:\> "%plesk_dir%"\\MySQL\\bin\\mysql -uadmin -p -P3306 client_base < client_base.dump
Note: just copying folder with database name from
'%plesk_dir%Databases\MySQL\data\' directory is not a correct way of backing up.
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.