How to Copy a Database in Plesk December 7, 2023

This article explains why and how to copy (duplicate) a database in the Plesk control panel.

Copying a database is useful when you want to:

• Create a backup before making changes
• Clone a website or application
• Test updates without affecting the live database
• Migrate or duplicate data safely

Steps to Copy a Database in Plesk:

1. Log in to your Plesk.
2. Select the Databases option.
   
3. Select the Database to copy.
   
4. Click Copy Database.
   
5. A form-type page will appear. Configure the following fields:
   1. Destination database server:
      Select the database server where the copied database will be created (for example, localhost:3306, default for MariaDB/MySQL).
   2. Destination webspace:
      Choose the domain or subscription where the new database should belong.
   3. Destination database:
      Select Create database with name to create a new database, or choose Copy to existing database if you want to merge tables into an existing database.
   4. New database name:
      Enter a unique name for the new database.
   5. Create a full copy:
      Keep this option enabled to copy both the database structure and data. If disabled, only the table structure will be copied.
      Warning: If you copy data into an existing database and table names match, the destination tables will be overwritten.
6. Click OK to begin copying the database.
   

In this way, you can copy a database in Plesk. For more information on Plesk, visit our knowledge base section.