Plesk allows you to copy databases from one database server registered in Plesk to another, as well as to any remote server, provided that the source and the destination servers are of the same type, for example, MySQL.
You can copy a database by running Websites & Domains > Databases > Copy for this database and specifying the destination server, the subscription and the database name. For a remote server, you should select Other in the Database destination server list and provide the following additional information:
- Host name or IP address of the remote database server.
- Username and password of the remote database server’s administrator. For example, the MySQL administrator’s credentials.
Note: When you choose an existing database as a destination, those tables in the destination database whose names also appear in the source database will be fully replaced.
Types of Copy
When you copy a database, you can choose whether to create a full database copy including data in the tables (the Create a full copy option), or to copy only the database structure. In the latter case, Plesk will create tables without data in the destination database.