{"id":814,"date":"2024-10-20T21:03:36","date_gmt":"2024-10-20T15:33:36","guid":{"rendered":"https:\/\/vpswebhostingindia.com\/blog\/?p=814"},"modified":"2024-10-20T21:04:30","modified_gmt":"2024-10-20T15:34:30","slug":"how-to-copy-a-database-in-plesk","status":"publish","type":"post","link":"https:\/\/vpswebhostingindia.com\/blog\/how-to-copy-a-database-in-plesk\/","title":{"rendered":"How to copy a database in Plesk"},"content":{"rendered":"\n<p>Copy a database in <a href=\"https:\/\/www.plesk.com\/\" rel=\"nofollow noopener\" target=\"_blank\">Plesk <\/a>is a useful process when you need to create backups, test environments, or migrate databases between domains or <a href=\"https:\/\/www.vpswebhostingindia.com\/vps-hosting\/\" rel=\"nofollow\">servers<\/a>. Plesk provides a user-friendly interface for this task, allowing you to duplicate a database in just a few clicks. This guide will walk you through the process of copying a database in Plesk, whether by using the built-in database copy feature or manually exporting and importing via <strong><a href=\"https:\/\/www.phpmyadmin.net\/\" rel=\"nofollow noopener\" target=\"_blank\">phpMyAdmin<\/a><\/strong>.<\/p>\n\n\n\n<div class=\"wp-block-rank-math-toc-block\" id=\"rank-math-toc\"><h2>Table of Contents<\/h2><nav><ul><li><a href=\"#step-1-log-into-plesk\">Step 1: Log into Plesk<\/a><\/li><li><a href=\"#step-2-access-the-databases-section\">Step 2: Access the Databases Section<\/a><\/li><li><a href=\"#step-3-select-the-database-you-want-to-copy\">Step 3: Select the Database You Want to Copy<\/a><\/li><li><a href=\"#step-4-configure-the-copy-settings\">Step 4: Copy a database in Plesk<\/a><\/li><li><a href=\"#step-5-verify-the-copied-database\">Step 5: Verify the Copied Database<\/a><\/li><li><a href=\"#alternative-method-manual-copy-via-php-my-admin\">Alternative Method: Manual Copy via phpMyAdmin<\/a><ul><li><a href=\"#step-1-export-the-original-database\">Step 1: Export the Original Database<\/a><\/li><li><a href=\"#step-2-create-a-new-database-in-plesk\">Step 2: Create a New Database in Plesk<\/a><\/li><li><a href=\"#step-3-import-the-data-into-the-new-database\">Step 3: Import the Data into the New Database<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-1-log-into-plesk\">Step 1: Log into Plesk<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open your preferred web browser and navigate to your <strong>Plesk Control Panel<\/strong> login page, which is typically provided by your hosting provider.<\/li>\n\n\n\n<li>Enter your <strong>username<\/strong> and <strong>password<\/strong>, then click on <strong>Log In<\/strong> to access your account.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"441\" height=\"491\" src=\"https:\/\/vpswebhostingindia.com\/blog\/wp-content\/uploads\/2024\/10\/image.png\" alt=\"\" class=\"wp-image-815\" style=\"width:276px;height:auto\" srcset=\"https:\/\/vpswebhostingindia.com\/blog\/wp-content\/uploads\/2024\/10\/image.png 441w, https:\/\/vpswebhostingindia.com\/blog\/wp-content\/uploads\/2024\/10\/image-180x200.png 180w\" sizes=\"auto, (max-width: 441px) 100vw, 441px\" \/><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"step-2-access-the-databases-section\">Step 2: Access the Databases Section<\/h3>\n\n\n\n<p>Once you&#8217;re logged in to Plesk, follow these steps:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>On the left-hand menu or at the top of the screen (depending on your version of Plesk), click on <strong>Websites &amp; <a href=\"https:\/\/www.vpswebhostingindia.com\/domain-registration\/\">Domains<\/a><\/strong>. This section provides a view of all the domains and websites you manage under your account.<\/li>\n\n\n\n<li>Scroll down to the <strong>Databases<\/strong> section. Here, you will see a list of databases associated with your websites or hosting plan.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"183\" src=\"https:\/\/vpswebhostingindia.com\/blog\/wp-content\/uploads\/2024\/10\/Screenshot_86_censored-1-1024x183.jpg\" alt=\"\" class=\"wp-image-816\" srcset=\"https:\/\/vpswebhostingindia.com\/blog\/wp-content\/uploads\/2024\/10\/Screenshot_86_censored-1-1024x183.jpg 1024w, https:\/\/vpswebhostingindia.com\/blog\/wp-content\/uploads\/2024\/10\/Screenshot_86_censored-1-300x54.jpg 300w, https:\/\/vpswebhostingindia.com\/blog\/wp-content\/uploads\/2024\/10\/Screenshot_86_censored-1-768x138.jpg 768w, https:\/\/vpswebhostingindia.com\/blog\/wp-content\/uploads\/2024\/10\/Screenshot_86_censored-1.jpg 1038w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-3-select-the-database-you-want-to-copy\">Step 3: Select the Database You Want to Copy<\/h3>\n\n\n\n<p>In the <strong>Databases<\/strong> section, locate the database that you would like to copy. You should see a list of all databases under the relevant domains.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Next to the database name you want to duplicate, click on the <strong>Copy<\/strong>. (The wording may vary depending on your version of Plesk, but the function is the same.)<\/li>\n\n\n\n<li>This will bring up the options for copy a database in Plesk.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"758\" height=\"241\" src=\"https:\/\/vpswebhostingindia.com\/blog\/wp-content\/uploads\/2024\/10\/Screenshot_87_censored.jpg\" alt=\"copy a database in Plesk\" class=\"wp-image-817\" srcset=\"https:\/\/vpswebhostingindia.com\/blog\/wp-content\/uploads\/2024\/10\/Screenshot_87_censored.jpg 758w, https:\/\/vpswebhostingindia.com\/blog\/wp-content\/uploads\/2024\/10\/Screenshot_87_censored-300x95.jpg 300w\" sizes=\"auto, (max-width: 758px) 100vw, 758px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-4-configure-the-copy-settings\">Step 4: Copy a database in Plesk<\/h3>\n\n\n\n<p>When you initiate the copy a database in Plesk, a form will appear with several options for configuring the copied database:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Database Name<\/strong>: Enter a new, unique name for the copied database. This name should be easily identifiable, especially if you&#8217;re creating multiple copies or backups.<\/li>\n\n\n\n<li><strong>Destination <\/strong>: Depending on your hosting configuration, you may have the option to copy the database within the same subscription or to another subscription if multiple subscriptions are available.<\/li>\n\n\n\n<li><strong>Copy Data<\/strong>: Ensure that the option to copy a database in Plesk is selected. This will copy not only the database structure but also the data within the tables.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"528\" height=\"352\" src=\"https:\/\/vpswebhostingindia.com\/blog\/wp-content\/uploads\/2024\/10\/Screenshot_88.png\" alt=\"\" class=\"wp-image-818\" srcset=\"https:\/\/vpswebhostingindia.com\/blog\/wp-content\/uploads\/2024\/10\/Screenshot_88.png 528w, https:\/\/vpswebhostingindia.com\/blog\/wp-content\/uploads\/2024\/10\/Screenshot_88-300x200.png 300w\" sizes=\"auto, (max-width: 528px) 100vw, 528px\" \/><\/figure>\n\n\n\n<p>Once you\u2019ve entered the necessary information and chosen your settings, click <strong>OK<\/strong> or <strong>Start<\/strong> to begin the copy a database in Plesk. Plesk will then duplicate the database, and the time required will depend on the size of the original database.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"step-5-verify-the-copied-database\">Step 5: Verify the Copied Database<\/h3>\n\n\n\n<p>Once the copy process is complete, return to the <strong>Databases<\/strong> section to verify that the new database has been successfully created. The newly copied database will appear in the list, and it will have the name you specified during the copy process.<\/p>\n\n\n\n<p>From here, you can access the new database, manage it, or make changes as needed.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"alternative-method-manual-copy-via-php-my-admin\">Alternative Method: Manual Copy via phpMyAdmin<\/h3>\n\n\n\n<p>If your version of Plesk doesn\u2019t provide a direct copy a database in Plesk feature or you prefer a manual approach, you can use <strong>phpMyAdmin<\/strong> to export and import the database manually.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"step-1-export-the-original-database\">Step 1: Export the Original Database<\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li>In the <strong><a href=\"https:\/\/www.mysql.com\/\" rel=\"nofollow noopener\" target=\"_blank\">Databases<\/a><\/strong> section of Plesk, find the database you want to copy, and click on <strong>phpMyAdmin<\/strong>.<\/li>\n\n\n\n<li>Once in <strong>phpMyAdmin<\/strong>, select the database you want to copy from the left-hand side.<\/li>\n\n\n\n<li>Click on the <strong>Export<\/strong> tab at the top of the screen.<\/li>\n\n\n\n<li>Choose the <strong>Quick<\/strong> export method and make sure the export format is set to <strong>SQL<\/strong>.<\/li>\n\n\n\n<li>Click <strong>Go<\/strong>, and the database will be downloaded as an SQL file to your computer.<\/li>\n<\/ol>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"step-2-create-a-new-database-in-plesk\">Step 2: Create a New Database in Plesk<\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Go back to the <strong>Databases<\/strong> section in Plesk.<\/li>\n\n\n\n<li>Click on <strong>Add Database<\/strong> to create a new database. Give the new database a unique name and assign it to a user.<\/li>\n\n\n\n<li>Once the new database is created, you\u2019ll see it listed in the <strong>Databases<\/strong> section.<\/li>\n<\/ol>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"step-3-import-the-data-into-the-new-database\">Step 3: Import the Data into the New Database<\/h4>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Next to your new database, click on <strong>phpMyAdmin<\/strong> to access it.<\/li>\n\n\n\n<li>In <strong>phpMyAdmin<\/strong>, select the new (empty) database from the left-hand side.<\/li>\n\n\n\n<li>Click on the <strong>Import<\/strong> tab at the top of the screen.<\/li>\n\n\n\n<li>Click <strong>Choose File<\/strong> and select the SQL file that you previously exported.<\/li>\n\n\n\n<li>After selecting the file, click <strong>Go<\/strong> to import the data into the new database.<\/li>\n<\/ol>\n\n\n\n<p>copy a database in Plesk is a simple yet powerful process for creating backups, clones, or testing environments. You can either use Plesk&#8217;s built-in <strong>Copy<\/strong> feature, which automates the process, or manually copy the database using <strong>phpMyAdmin<\/strong>. The choice of method depends on your preferences and the version of Plesk you are using. Always ensure you name your databases clearly and understand the implications of duplicating large databases to avoid performance issues or exceeding storage limits.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Copy a database in Plesk is a useful process when you need to create backups, test environments, or migrate databases between domains or servers. Plesk provides a user-friendly interface for this task, allowing you to duplicate a database in just a few clicks. This guide will walk you through the process of copying a database [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":821,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,7,33],"tags":[53],"class_list":["post-814","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-control-panel","category-data-base","category-plesk","tag-copy-a-database-in-plesk"],"_links":{"self":[{"href":"https:\/\/vpswebhostingindia.com\/blog\/wp-json\/wp\/v2\/posts\/814","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vpswebhostingindia.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vpswebhostingindia.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vpswebhostingindia.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vpswebhostingindia.com\/blog\/wp-json\/wp\/v2\/comments?post=814"}],"version-history":[{"count":2,"href":"https:\/\/vpswebhostingindia.com\/blog\/wp-json\/wp\/v2\/posts\/814\/revisions"}],"predecessor-version":[{"id":820,"href":"https:\/\/vpswebhostingindia.com\/blog\/wp-json\/wp\/v2\/posts\/814\/revisions\/820"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vpswebhostingindia.com\/blog\/wp-json\/wp\/v2\/media\/821"}],"wp:attachment":[{"href":"https:\/\/vpswebhostingindia.com\/blog\/wp-json\/wp\/v2\/media?parent=814"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vpswebhostingindia.com\/blog\/wp-json\/wp\/v2\/categories?post=814"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vpswebhostingindia.com\/blog\/wp-json\/wp\/v2\/tags?post=814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}