{"id":2015,"date":"2019-10-21T11:07:44","date_gmt":"2019-10-21T03:07:44","guid":{"rendered":"https:\/\/www.mondoze.com\/guide\/?post_type=kb&#038;p=2015"},"modified":"2022-10-05T08:04:20","modified_gmt":"2022-10-05T00:04:20","slug":"clone-database-using-phpmyadmin","status":"publish","type":"kb","link":"https:\/\/www.mondoze.com\/guide\/kb\/clone-database-using-phpmyadmin","title":{"rendered":"Clone database using PhpMyAdmin"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"2015\" class=\"elementor elementor-2015\" data-elementor-settings=\"[]\">\n\t\t\t\t\t\t<div class=\"elementor-inner\">\n\t\t\t\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6f47eff5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6f47eff5\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-59b04569\" data-id=\"59b04569\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6e3413d elementor-widget elementor-widget-heading\" data-id=\"6e3413d\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">How To Clone Database using phpMyAdmin<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-17b4933c elementor-widget elementor-widget-text-editor\" data-id=\"17b4933c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p style=\"font-weight: 400;\">This guide is for users who want to clone their MySQL database through phpMyAdmin.<\/p><p style=\"font-weight: 400;\">Besides using the command line or dashboard to export, import way to duplicate a database, user have the option to use phpMyadmin function to clone their database.<\/p><p style=\"font-weight: 400;\">After accessing phpMyAdmin via cPanel \/ Helm \/ WebSitePanel,<\/p><ol style=\"font-weight: 400;\"><li>Select the database user want to copy (by clicking on the database from the phpMyAdmin home screen).<\/li><li>Once inside the database, select the\u00a0<strong>Operations<\/strong>\u00a0tab.<\/li><li>Scroll down to the section where it says &#8220;<strong>Copy database to:<\/strong>&#8220;<\/li><li>Type in the name of the new database.<\/li><li>Select &#8220;<strong>structure and data<\/strong>&#8221; to copy everything. Alternately, user can select &#8220;Structure only&#8221; if user want the columns but not the data.<\/li><li>Check the box &#8220;<strong>CREATE DATABASE before copying<\/strong>&#8221; to create a new database.<\/li><li>Check the box &#8220;<strong>Add AUTO_INCREMENT value<\/strong>.&#8221;<\/li><li>Click on the\u00a0<strong>Go<\/strong>\u00a0button to proceed.<\/li><\/ol><p style=\"font-weight: 400;\">If click on the home icon, user will notice the new database listed in the left column. By going inside, user will find the database is a copy of the previous database.<\/p><p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-2016\" src=\"https:\/\/www.mondoze.com\/guide\/wp-content\/uploads\/2021\/03\/pngbase64e4108d7c32595074-300x110.png\" alt=\"\" width=\"300\" height=\"110\" \/><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>How To Clone Database using phpMyAdmin This guide is for users who want to clone their MySQL database through phpMyAdmin. Besides using the command line or dashboard to export, import way to duplicate a database, user have the option to use phpMyadmin function to clone their database. After accessing phpMyAdmin via cPanel \/ Helm \/ &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.mondoze.com\/guide\/kb\/clone-database-using-phpmyadmin\"> <span class=\"screen-reader-text\">Clone database using PhpMyAdmin<\/span> Read More \u00bb<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","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":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"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-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-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-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-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-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-gradient":""}}},"kbtopic":[38],"kbtag":[110],"mkb_version":[],"_links":{"self":[{"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kb\/2015"}],"collection":[{"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/comments?post=2015"}],"version-history":[{"count":7,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kb\/2015\/revisions"}],"predecessor-version":[{"id":18487,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kb\/2015\/revisions\/18487"}],"wp:attachment":[{"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/media?parent=2015"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kbtopic?post=2015"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kbtag?post=2015"},{"taxonomy":"mkb_version","embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/mkb_version?post=2015"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}