Copying Databases

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.

 

Leave your comments on this page

Leave your feedback or question on this documentation topic below. For technical assistance, contact your hosting service provider or submit a request to Plesk support. Suggest new features for Plesk here. Discuss general questions on the Plesk forum. All offtopic comments will be removed.