Question
How to transfer a MySQL database from one MySQL server to another? For example:
- from a local MySQL server to remote, which is attached to Plesk
- from one Plesk server to another
Answer
-
Go to Domains > example.com > Databases.
-
Click Copy under the database that needs to be copied.
-
Fill in the fields:
-
Select a remote database server from the drop-down list.
-
Choose either to copy the database to a new or existing one.
Note: The will appear only if a remote database already exist in Plesk.
-
-
Click OK and wait fore the operation to complete.
-
Go to Domains > example.com > Databases.
-
Click Export Dump under the database that needs to be copied.
-
In the opened window, select “Automatically download dump after creation” and click OK.
-
Save the dump to your device.
-
Create a new database with the same name on another Plesk server.
-
Upload the MySQL dump from step 4 using the Import Dump button.
with