{"id":5224,"date":"2020-06-02T14:00:34","date_gmt":"2020-06-02T08:30:34","guid":{"rendered":"https:\/\/phpyouth.com\/blog\/?p=5224"},"modified":"2026-01-21T13:32:11","modified_gmt":"2026-01-21T08:02:11","slug":"create-duplicate-database-using-phpmyadmin","status":"publish","type":"post","link":"https:\/\/phpyouth.com\/blog\/create-duplicate-database-using-phpmyadmin\/","title":{"rendered":"How to make Duplicate\/Clone\/Copy Database using PHPMyAdmin"},"content":{"rendered":"<p>Hello Friends, how are you? I hope all are feeling well, safe, and at home in this <em>pandemic<\/em>. I also want to say sorry for not publishing an article in the last <em>75 days<\/em>. So today we started again with a new topic, can&#8217;t say new but yes it&#8217;s who don&#8217;t know. Today, we learn <strong>how to make a duplicate\/Clone\/Copy Database using PHPMyAdmin<\/strong>.<\/p>\n<h2>Why Do We Need to Copy a Database Using PHPMyAdmin?<\/h2>\n<p>But first, we will discuss why we need to <strong>copy the database using PHPMyAdmin<\/strong>. Sometimes you face this situation where you are unable to clone a WordPress site on the same server due to its size, and all cloning tools fail to do this; they want to upgrade the tool first to the premium\/PRO version. LOL, actually, I have faced the same situation as well. That website I tried to clone had a 1GB file and a 700MB Database backup. So that&#8217;s the reason I write this article, so no one can face this torture.<\/p>\n<h2>Benefits of Copying a Database Using PHPMyAdmin<\/h2>\n<p>From this article, we will not need to download and then upload the database again on the same server for cloning. Duplicate\/Clone\/Copy Database using PHPMyAdmin will save you a lot. So let&#8217;s start, follow the steps I have mentioned.<\/p>\n<ul>\n<li>Log in to your <a href=\"https:\/\/hosting.phpyouth.com\/\"><em>cPanel<\/em><\/a><\/li>\n<li>Click <strong>PHPMyAdmin<\/strong><\/li>\n<li>Select the Database you want to make a copy or duplicate.<\/li>\n<li>Once you select the database, click on the <strong>Operations<\/strong> tab.<br \/>\n<a href=\"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2026\/01\/click-operation.webp?ssl=1\"><img data-recalc-dims=\"1\" height=\"1024\" width=\"1024\" decoding=\"async\" class=\"alignnone size-large wp-image-5240\" src=\"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2026\/01\/click-operation.webp?fit=1024%2C1024&#038;ssl=1\" alt=\"database-operation-tab\" \/><\/a><\/li>\n<\/ul>\n<ul>\n<li>Once the <strong>Operations<\/strong> tab opens, scroll down to the section where it says <strong>Copy Database to:<\/strong>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li>Type the name of your new database.<\/li>\n<li>Select <strong>Structure and Data<\/strong> to copy everything.<\/li>\n<li>Then select <strong>CREATE DATABASE before copying<\/strong> to create a new database<\/li>\n<li>At last, Select <strong>Add AUTO_INCREMENT value<\/strong><\/li>\n<li>Finally hit the <strong>Go<\/strong> button, see the screenshot below screenshot<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p><a href=\"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2026\/01\/Copied-database.webp?ssl=1\"><img data-recalc-dims=\"1\" height=\"1024\" width=\"1024\" decoding=\"async\" class=\"aligncenter size-large wp-image-5241\" src=\"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2026\/01\/Copied-database.webp?fit=1024%2C1024&#038;ssl=1\" alt=\"Copied-database\" \/><\/a><\/li>\n<li>Once you hit the <strong>Go<\/strong> button, your database will be successfully copied to the new database. Check the screenshots<\/li>\n<\/ul>\n<p><a href=\"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2026\/01\/copying-database.webp?ssl=1\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"aligncenter wp-image-5244\" src=\"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2026\/01\/copying-database.webp?ssl=1\" alt=\"copying-database-using-phpmyadmin\" \/><\/a><br \/>\n<a href=\"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2026\/01\/copied-successfully.webp?ssl=1\"><img data-recalc-dims=\"1\" height=\"1024\" width=\"1024\" decoding=\"async\" class=\"aligncenter size-large wp-image-5242\" src=\"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2026\/01\/copied-successfully.webp?fit=1024%2C1024&#038;ssl=1\" alt=\"database copy\" \/><\/a><br \/>\n<a href=\"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2026\/01\/Cloned-database-successfully.webp?ssl=1\"><img data-recalc-dims=\"1\" height=\"1024\" width=\"1024\" decoding=\"async\" class=\"aligncenter size-large wp-image-5243\" src=\"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2026\/01\/Cloned-database-successfully.webp?fit=1024%2C1024&#038;ssl=1\" alt=\"Clone-database-successfully-using-phpmyadmin\" \/><\/a><\/p>\n<h2>Important Note: After Copying Database<\/h2>\n<p>During the process, the Username and Password for the Database were not generated, so you have to create a new Username and Password for the Database and assign all privileges.<\/p>\n<p><strong>PS:<\/strong> <a href=\"https:\/\/phpyouth.com\/blog\/add-an-administrator-from-wordpress-mysql-database\">How to add a WordPress Administrator from the MySQL Database<\/a><\/p>\n<h2>Conclusion<\/h2>\n<p>So friends, if this article is really helpful for you, then please share your thoughts and your experience while doing this in the comment box. I will be waiting. Keep learning and sharing.<\/p>\n<p><a href=\"https:\/\/www.hostg.xyz\/aff_c?offer_id=6&amp;aff_id=115521&amp;url_id=35&amp;file_id=1399\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/media.go2speed.org\/brand\/files\/hostinger\/6\/EN-970x250.jpg?resize=970%2C250&#038;ssl=1\" width=\"970\" height=\"250\" border=\"0\" alt=\"\"><\/a><img decoding=\"async\" style=\"position: absolute; visibility: hidden;\" src=\"https:\/\/www.hostg.xyz\/aff_i?offer_id=6&amp;file_id=1399&amp;aff_id=115521&amp;url_id=35\" width=\"0\" height=\"0\" border=\"0\" alt=\"\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hello Friends, how are you? I hope all are feeling well, safe, and at home in this pandemic. I also want to say sorry for not publishing an article in the last 75 days. So today we started again with a new topic, can&#8217;t say new but yes it&#8217;s who don&#8217;t know. Today, we learn [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":11966,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[101,150,100,186],"tags":[215,214,512,516,513,514,118,515,517],"class_list":["post-5224","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","category-cpanel","category-mysql","category-phpmyadmin","tag-copy-database","tag-database","tag-database-backup","tag-database-management","tag-database-migration","tag-mysql-database","tag-phpmyadmin","tag-phpmyadmin-tutorial","tag-website-cloning"],"acf":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2026\/01\/Duplicate-Clone-Copy-Database-using-PHPMyAdmin.webp?fit=560%2C315&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8zepR-1mg","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":4620,"url":"https:\/\/phpyouth.com\/blog\/how-to-fix-1273-unknow-collation-utf8mb4_unicode_520_ci-mysql-query-error\/","url_meta":{"origin":5224,"position":0},"title":"How to fix #1273 &#8211; Unknow collation: &#8216;utf8mb4_unicode_520_ci&#8217; MySQL query error","author":"RK Jajoria","date":"December 8, 2017","format":false,"excerpt":"Hello Friends, today we will learn how to resolve the MySQL error 1273 utf8mb4_unicode_520_ci in WordPress. This MySQL error #1273 - Unknown collation: 'utf8mb4_unicode_520_ci' often occurs when importing a WordPress database. This specific MySQL error often occurs when importing a WordPress database from one host to another using PHPMyAdmin. It\u2026","rel":"","context":"In &quot;Database&quot;","block_context":{"text":"Database","link":"https:\/\/phpyouth.com\/blog\/category\/web-hosting\/database\/"},"img":{"alt_text":"utf8mb4_unicode_520_ci","src":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2017\/12\/1273-%E2%80%93-Unknow-collation-%E2%80%98utf8mb4_unicode_520_ci%E2%80%99.png?fit=560%2C315&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2017\/12\/1273-%E2%80%93-Unknow-collation-%E2%80%98utf8mb4_unicode_520_ci%E2%80%99.png?fit=560%2C315&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2017\/12\/1273-%E2%80%93-Unknow-collation-%E2%80%98utf8mb4_unicode_520_ci%E2%80%99.png?fit=560%2C315&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":5000,"url":"https:\/\/phpyouth.com\/blog\/remove-wc_sessions-in-woocommerce\/","url_meta":{"origin":5224,"position":1},"title":"How to Remove wc_sessions in WooCommerce","author":"RK Jajoria","date":"July 4, 2019","format":false,"excerpt":"Hello friends! Today, in this tutorial, we will learn how to remove sessions in WooCommerce. First, we will discuss why we need to remove these sessions from WooCommerce. These sessions make the wp_options table heavy in size. WooCommerce stores the _wc_session_xxx and _wc_session_expires_xxx entries in the wp_options table. There are\u2026","rel":"","context":"In &quot;Plugins&quot;","block_context":{"text":"Plugins","link":"https:\/\/phpyouth.com\/blog\/category\/wordpress\/plugins\/"},"img":{"alt_text":"Remove woocommerce sessions","src":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2019\/07\/Remove-woocommerce-sessions.png?fit=560%2C315&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2019\/07\/Remove-woocommerce-sessions.png?fit=560%2C315&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2019\/07\/Remove-woocommerce-sessions.png?fit=560%2C315&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":4462,"url":"https:\/\/phpyouth.com\/blog\/add-administrator-user-in-wordpress-using-mysql\/","url_meta":{"origin":5224,"position":2},"title":"Add Administrator User in WordPress Using MySQL","author":"RK Jajoria","date":"September 8, 2017","format":false,"excerpt":"Friends, In today\u2019s article, we\u2019ll learn how to add an administrator user to WordPress using MySQL. Yesterday, my best friend reached out to me because his WordPress site was hacked, and his admin account was deleted. He asked me how he could add a new administrator without accessing the WordPress\u2026","rel":"","context":"In &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/phpyouth.com\/blog\/category\/web-hosting\/database\/mysql\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2017\/09\/2.png?fit=560%2C315&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2017\/09\/2.png?fit=560%2C315&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2017\/09\/2.png?fit=560%2C315&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":4443,"url":"https:\/\/phpyouth.com\/blog\/4-vital-monthly-wordpress-maintenance-tasks\/","url_meta":{"origin":5224,"position":3},"title":"4 Vital Monthly WordPress Maintenance Tasks","author":"RK Jajoria","date":"July 16, 2018","format":false,"excerpt":"Hello Friends, today we will learn about 4 Vital Monthly WordPress Maintenance tasks which we need to do regularly. But first, we need to understand why WordPress maintenance is important. We think that once our\u00a0 WordPress website is completed and live, our work is over, but that's not true. If\u2026","rel":"","context":"In &quot;Maintenance&quot;","block_context":{"text":"Maintenance","link":"https:\/\/phpyouth.com\/blog\/category\/wordpress\/maintenance\/"},"img":{"alt_text":"wordpress maintenance","src":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2018\/07\/wordpress-maintenance.png?fit=560%2C315&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2018\/07\/wordpress-maintenance.png?fit=560%2C315&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2018\/07\/wordpress-maintenance.png?fit=560%2C315&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":4508,"url":"https:\/\/phpyouth.com\/blog\/change-site-language-wordpress\/","url_meta":{"origin":5224,"position":4},"title":"How to change Site language in WordPress","author":"RK Jajoria","date":"September 19, 2017","format":false,"excerpt":"Hello Friends, today we will learn about\u00a0How to change Site language in WordPress. Let me first tell you guys why we wrote this article today. A few days ago, one of my subscribers asked me that he is having a problem in the approval of Google Adsense on his website.\u2026","rel":"","context":"In &quot;Wordpress&quot;","block_context":{"text":"Wordpress","link":"https:\/\/phpyouth.com\/blog\/category\/wordpress\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2017\/09\/1-1.png?fit=560%2C315&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2017\/09\/1-1.png?fit=560%2C315&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2017\/09\/1-1.png?fit=560%2C315&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":5178,"url":"https:\/\/phpyouth.com\/blog\/woocommerce-released-3-9-in-2020\/","url_meta":{"origin":5224,"position":5},"title":"WooCommerce Released 3.9 in 2020","author":"RK Jajoria","date":"January 29, 2020","format":false,"excerpt":"Hello Friends, I just received an email from Woocommerce regarding their new version released. So I thought you guys also know that WooCommerce Released 3.9 in 2020. So friends please read the article till the end and share your experience. The year 2020, a new decade started and January month\u2026","rel":"","context":"In &quot;WooCommerce&quot;","block_context":{"text":"WooCommerce","link":"https:\/\/phpyouth.com\/blog\/category\/wordpress\/plugins\/woocommerce\/"},"img":{"alt_text":"WooCommerce3.9","src":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2020\/01\/WooCommerce3.9.png?fit=560%2C315&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2020\/01\/WooCommerce3.9.png?fit=560%2C315&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/phpyouth.com\/blog\/wp-content\/uploads\/2020\/01\/WooCommerce3.9.png?fit=560%2C315&ssl=1&resize=525%2C300 1.5x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/posts\/5224","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/comments?post=5224"}],"version-history":[{"count":0,"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/posts\/5224\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/media\/11966"}],"wp:attachment":[{"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/media?parent=5224"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/categories?post=5224"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpyouth.com\/blog\/wp-json\/wp\/v2\/tags?post=5224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}