How to backup client MySQL database manually?
If MySQL server is running, you can backup database with the following command:
C:> "%plesk_dir%"\MySQL\bin\mysqldump -uadmin -p -P3306 client_base > client_base.dump
3306 - port for MySQL server client_base is name of database client_base.dump is name of backup database
You can restore it on another server with the following command:
C:> "%plesk_dir%"\MySQL\bin\mysql -uadmin -p -P3306 client_base < client_base.dump
Please note that IT IS NOT CORRECT procedure to just copy folder with database name from
'C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL\data\' and move it to another server. In databases with InnoDB engine, data and indexes of innodb tables are stored in
'ibdata1' file. If you want to move database to another server you should either:
Backup database through Plesk, download it and restore backup on another server.
- Manually dump data with
'mysqldump'command, as mentioned above, and restore backup on another server.