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.