{"id":221,"date":"2015-04-08T11:02:23","date_gmt":"2015-04-08T11:02:23","guid":{"rendered":"http:\/\/angelwings.net\/blog\/?p=221"},"modified":"2015-04-08T11:02:23","modified_gmt":"2015-04-08T11:02:23","slug":"mysql-how-to-copy-a-database-in-phpmyadmin","status":"publish","type":"post","link":"https:\/\/angelwings.net\/blog\/mysql-how-to-copy-a-database-in-phpmyadmin\/","title":{"rendered":"mysql: How to copy a database in phpMyAdmin"},"content":{"rendered":"<p>How to copy a database in phpMyAdmin<\/p>\n<p>This tutorial will demonstrate how to copy or duplicate a database in phpMyAdmin.<\/p>\n<p>Begin by accessing phpMyAdmin via cPanel .<\/p>\n<p>    Select the database you wish to copy (by clicking on the database from the phpMyAdmin home screen).<br \/>\n    Once inside the database, select the Operations tab.<br \/>\n    Scroll down to the section where it says &#8220;Copy database to:&#8221;<br \/>\n    Type in the name of the new database.<br \/>\n    Select &#8220;structure and data&#8221; to copy everything.  Alternately, you can select &#8220;Structure only&#8221; if you want the columns but not the data.<br \/>\n    Check the box &#8220;CREATE DATABASE before copying&#8221; to create a new database.<br \/>\n    Check the box &#8220;Add AUTO_INCREMENT value.&#8221;<br \/>\n    Click on the Go button to proceed.<\/p>\n<p>If you click on the home icon, you will notice your new database listed in the left column.  If you go inside, you will see the database is a copy of the previous database.<br \/>\nSource: https:\/\/my.bluehost.com\/cgi\/help\/2154<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to copy a database in phpMyAdmin This tutorial will demonstrate how to copy or duplicate a database in phpMyAdmin. Begin by accessing phpMyAdmin via cPanel . Select the database you wish to copy (by clicking on the database from the phpMyAdmin home screen). Once inside the database, select the Operations tab. Scroll down to [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[89,98],"class_list":["post-221","post","type-post","status-publish","format-standard","hentry","category-database","tag-mysql","tag-phpmyadmin"],"_links":{"self":[{"href":"https:\/\/angelwings.net\/blog\/wp-json\/wp\/v2\/posts\/221","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/angelwings.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/angelwings.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/angelwings.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/angelwings.net\/blog\/wp-json\/wp\/v2\/comments?post=221"}],"version-history":[{"count":0,"href":"https:\/\/angelwings.net\/blog\/wp-json\/wp\/v2\/posts\/221\/revisions"}],"wp:attachment":[{"href":"https:\/\/angelwings.net\/blog\/wp-json\/wp\/v2\/media?parent=221"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/angelwings.net\/blog\/wp-json\/wp\/v2\/categories?post=221"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/angelwings.net\/blog\/wp-json\/wp\/v2\/tags?post=221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}