- Plesk 12.5 for Windows
How to manually migrate a MySQL database
from another Plesk?
I. Take a dump on the source server
Go to Server > Database servers > MySQL servername > databases and click
db_nameto see the database users list
Contact the database owner to get the database user password. Or just reset it at Server > Database servers > Database server management > db_name > db_user
Take the database dump:
"%plesk_dir%\\MySQL\\bin\\mysqldump.exe" -P3306 -udb_user -p********** --skip-extended-insert intranet > D:\\db_name.dump.sql
II. Transfer the database dump to the target server
In case of very big database file, it can be compressed to a ZIP file. Then, the ZIP file should be transferred to the target server. RDP connection can be used for it, for example. Unzip the file on the target.
III. Restore the dump on the target server
- Create an empty
- in Plesk administration panel, go to Subscriptions > example.com > databases and press "Add Database": - database name: db_name - Related site: db_name.example.com - database username: db_user - password: * *
- Restore the database content:
"%plesk_dir%\\MySQL\\bin\\mysql.exe" -P3306 -udb_user -p******* db_name < D:\\db_name.dump.sql
Note: in case any issues appear during restoration of the database via command prompt, make sure that versions of mysql on the both source and destination servers are compatible.