{"id":7069,"date":"2020-01-21T08:57:25","date_gmt":"2020-01-21T08:57:25","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=7069"},"modified":"2020-01-21T08:57:25","modified_gmt":"2020-01-21T08:57:25","slug":"learn-to-use-phpmyadmin-to-copy-mysql-database","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-use-phpmyadmin-to-copy-mysql-database\/","title":{"rendered":"Learn to Use phpMyAdmin To Copy MySQL Database"},"content":{"rendered":"<p>In this article you will learn to copy MySQL database using phpMyAdmin.<\/p>\n<h3>Steps to Copy MySQL Database<\/h3>\n<p>In order to copy a MySQL database using phpMyAdmin, follow these steps:<\/p>\n<p>1. Log in to cPanel account.<\/p>\n<p>2. Under the <strong>Databases<\/strong> section of the cPanel home screen, click on <strong>phpMyAdmin<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8912\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/01\/cpanel-database-min.png\" alt=\"\" width=\"915\" height=\"231\" \/><\/p>\n<p>The phpMyAdmin administration page will get displayed in a new window.<\/p>\n<p>3. In the left pane, click on the name of the database that you want to copy.<\/p>\n<p>4. Click on <strong>Operations<\/strong> on the top menu bar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-8917\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/01\/database-selected-1-min-1024x496.png\" alt=\"\" width=\"1024\" height=\"496\" \/><\/p>\n<p>5. Under <strong>Copy database to<\/strong>, in the text box type the name that you want for the new database.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-8914\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/01\/copy-database-to-min-1024x358.png\" alt=\"\" width=\"1024\" height=\"358\" \/><\/p>\n<p>6. For copying everything into the new database, select <strong>Structure<\/strong> and data. Or if you only want to copy the database structure, select <strong>Structure<\/strong> only, and none of the data will be copied.<\/p>\n<p>7. Prior to copying check box, select the <strong>Create Database<\/strong>.<\/p>\n<p>8. Check the <strong>Add AUTO_INCREMENT<\/strong> value check box.<\/p>\n<p>9. Now, click on <strong>Go<\/strong>. With this, <strong>phpMyAdmin<\/strong> will create a new database using the name you mentioned in step 5, and then copies it. When it finishes, you will find the new database in the list of databases in the left pane.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-8915\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/01\/database-copied-min-1024x352.png\" alt=\"\" width=\"1024\" height=\"352\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-8916\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/01\/new-database-min-1024x498.png\" alt=\"\" width=\"1024\" height=\"498\" \/><\/p>\n<p>In this way, you can use phpMyAdmin to copy the MySQL database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this article you will learn to copy MySQL database using phpMyAdmin. Steps to Copy MySQL Database In order to copy a MySQL database using phpMyAdmin, follow these steps: 1. Log in to cPanel account. 2. Under the Databases section of the cPanel home screen, click on phpMyAdmin. The phpMyAdmin administration page will get displayed [&hellip;]<\/p>\n","protected":false},"author":16,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[947],"tags":[1220,1221,616],"class_list":["post-7069","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-mysql","tag-copy-mysql-database","tag-copy-mysql-database-using-phpmyadmin","tag-phpmyadmin"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Learn to Use phpMyAdmin To Copy MySQL Database<\/title>\n<meta name=\"description\" content=\"The article provides steps to copy the MySQL database using phpMyAdmin.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-use-phpmyadmin-to-copy-mysql-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Learn to Use phpMyAdmin To Copy MySQL Database\" \/>\n<meta property=\"og:description\" content=\"The article provides steps to copy the MySQL database using phpMyAdmin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-use-phpmyadmin-to-copy-mysql-database\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-21T08:57:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/01\/cpanel-database-min.png\" \/>\n<meta name=\"author\" content=\"Pallavi Godse\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pallavi Godse\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-use-phpmyadmin-to-copy-mysql-database\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-use-phpmyadmin-to-copy-mysql-database\/\",\"name\":\"Learn to Use phpMyAdmin To Copy MySQL Database\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-use-phpmyadmin-to-copy-mysql-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-use-phpmyadmin-to-copy-mysql-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/01\/cpanel-database-min.png\",\"datePublished\":\"2020-01-21T08:57:25+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945\"},\"description\":\"The article provides steps to copy the MySQL database using phpMyAdmin.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-use-phpmyadmin-to-copy-mysql-database\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-use-phpmyadmin-to-copy-mysql-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-use-phpmyadmin-to-copy-mysql-database\/#primaryimage\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/01\/domain-name-min.jpg\",\"contentUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/01\/domain-name-min.jpg\",\"width\":1569,\"height\":523},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-use-phpmyadmin-to-copy-mysql-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Learn to Use phpMyAdmin To Copy MySQL Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945\",\"name\":\"Pallavi Godse\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eefc9695ea2b2c6e143c9c9919701aaa?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eefc9695ea2b2c6e143c9c9919701aaa?s=96&d=blank&r=g\",\"caption\":\"Pallavi Godse\"},\"description\":\"Pallavi is a Digital Marketing Executive at MilesWeb and has an experience of over 4 years in content development. She is interested in writing engaging content on business, technology, web hosting and other topics related to information technology.\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/pallavi\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Learn to Use phpMyAdmin To Copy MySQL Database","description":"The article provides steps to copy the MySQL database using phpMyAdmin.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-use-phpmyadmin-to-copy-mysql-database\/","og_locale":"en_GB","og_type":"article","og_title":"Learn to Use phpMyAdmin To Copy MySQL Database","og_description":"The article provides steps to copy the MySQL database using phpMyAdmin.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-use-phpmyadmin-to-copy-mysql-database\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2020-01-21T08:57:25+00:00","og_image":[{"url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/01\/cpanel-database-min.png","type":"","width":"","height":""}],"author":"Pallavi Godse","twitter_misc":{"Written by":"Pallavi Godse","Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-use-phpmyadmin-to-copy-mysql-database\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-use-phpmyadmin-to-copy-mysql-database\/","name":"Learn to Use phpMyAdmin To Copy MySQL Database","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-use-phpmyadmin-to-copy-mysql-database\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-use-phpmyadmin-to-copy-mysql-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2020\/01\/cpanel-database-min.png","datePublished":"2020-01-21T08:57:25+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945"},"description":"The article provides steps to copy the MySQL database using phpMyAdmin.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-use-phpmyadmin-to-copy-mysql-database\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-use-phpmyadmin-to-copy-mysql-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-use-phpmyadmin-to-copy-mysql-database\/#primaryimage","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/01\/domain-name-min.jpg","contentUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/01\/domain-name-min.jpg","width":1569,"height":523},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-use-phpmyadmin-to-copy-mysql-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"Learn to Use phpMyAdmin To Copy MySQL Database"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/7e3952607fa9eb4e82fea9f7cad9c945","name":"Pallavi Godse","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eefc9695ea2b2c6e143c9c9919701aaa?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eefc9695ea2b2c6e143c9c9919701aaa?s=96&d=blank&r=g","caption":"Pallavi Godse"},"description":"Pallavi is a Digital Marketing Executive at MilesWeb and has an experience of over 4 years in content development. She is interested in writing engaging content on business, technology, web hosting and other topics related to information technology.","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/pallavi\/"}]}},"views":609,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/7069","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=7069"}],"version-history":[{"count":1,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/7069\/revisions"}],"predecessor-version":[{"id":7076,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/7069\/revisions\/7076"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=7069"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=7069"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=7069"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}