Make a MySQL DB copy in Plesk

Make a MySQL DB copy in Plesk

     Make a MySQL DB copy in Plesk

  • Steps to access DB using root

 Step 1: Visit the URL http://<your_domain>:8880 or https://<your_domain>:8443 (For SSL) and login.

 Step 2: Click on DB then select DB.

 
 

 Step 3: Click on copy link on a particular DB.


 

 Step 4: Select the destination DB server as localhost if you want to copy it within the same server.
   (Remember to check create a full copy, if want to copy the data from the DB as well as the structures also)

   A. You can create a new DB.


 

   B. If you want to modify it to an existing DB.


 

Step 5: \Also can copy the DB to any remote DB by selecting others on the dropdown.
   Enter the Hostname or IP address.
   Enter the Username and Password.
   (Remember to check create a full copy, if want to copy the data from the DB as well as the structures also)

   A. You can create a new DB.


 

   B. If want to modify to an existing DB.


 

Step 6: After clicking OK the DB copying process will start immediately.

  • You can view the copied DB into DB section

Step 1:  Now you can modify your website's scripts configuration, so they connect to the copied DB.


 



    • Related Articles

    • Backup and restore MySQL database with Plesk

      Backup and restore MySQL database with Plesk Description: In Plesk, database dumps are created in the SQL format and saved as ZIP archives. If you need to create a dump in another format or to set custom settings for a dump, use the native ...

    • Important Plesk CLI Commands

      Important Plesk Linux CLI Commands If Plesk throws an error, these logs will help. /usr/local/psa/var/log /opt/psa/admin/logs /var/log/sw-cp-server/error_log /usr/local/psa/admin/logs/panel.log /usr/local/psa/admin/logs/httpsd_access_log ...

    • How to create a Mysql or MSSQL DB in Plesk Panel

      Steps to create a DB and a DB user in Plesk Step 1: Login To the Plesk control panel. Step 2: Go to the DB. Step 3: Next page click Add DB Step 4: Assign a name to your DB within the DB name field and select the DB server Mysql or MSSQL from the ...

    • Bulk email ID creation on Plesk

      Bulk email ID creation on Plesk Follow the below steps to create Bulk Email ID on Plesk 1.Connect to the server via SSH/RDP. 2.Create a file mail.txt using any text editor with a list of mail addresses and passwords for it: example1@example.com ...

    • Plesk services logs and configuration files

      Plesk services logs and configuration files Plesk Logs Error log: /var/log/sw-cp-server/error_log Access log: /var/log/plesk/httpsd_access_log Panel log: /var/log/plesk/panel.log Configuration PHP config on RHEL-based: ...