{"id":453,"date":"2017-02-19T14:38:30","date_gmt":"2017-02-19T14:38:30","guid":{"rendered":"https:\/\/chemicloud.com\/kb\/?post_type=article&#038;p=453"},"modified":"2020-03-25T14:42:30","modified_gmt":"2020-03-25T14:42:30","slug":"exporting-databases-tables-phpmyadmin","status":"publish","type":"ht_kb","link":"https:\/\/chemicloud.com\/kb\/article\/exporting-databases-tables-phpmyadmin\/","title":{"rendered":"Exporting Databases and Tables With phpMyAdmin"},"content":{"rendered":"<p><span style=\"color: #494949; font-family: montserrat,sans-serif; font-size: 15px;\">This tutorial assumes you&#8217;ve already logged into phpMyAdmin. If you are not logged in just follow the steps in\u00a0<\/span><a style=\"color: #2a94e5; background: none; box-sizing: border-box; text-decoration: none; outline: none; line-height: 1; display: inline-block; font-family: Montserrat, sans-serif; font-size: 15px;\" href=\"https:\/\/chemicloud.com\/kb\/article\/how-to-use-phpmyadmin\/\">this tutorial<\/a><span style=\"color: #494949; font-family: montserrat,sans-serif; font-size: 15px;\">\u00a0to\u00a0login.<\/span><\/p>\n<p><strong>1)<\/strong> Click the database you wish to export, in this example we&#8217;ll use the <strong>chemiclo_demo <\/strong>database.<\/p>\n<p><strong>2)<\/strong> Next, click on the &#8220;<strong>Export<\/strong>&#8221; tab and select the format in which you want to export the database.<\/p>\n<p><strong>3)<\/strong> Click on the <strong>&#8220;Go&#8221;<\/strong> button to start the export\/backup process of the entire\u00a0database.<\/p>\n<p><strong>4)<\/strong> You can also export only certain tables from your database, from the export tab go to the &#8220;<strong>Export Method<\/strong>&#8221; section click on the &#8220;<strong>Custom &#8211; display all possible options<\/strong>&#8220;. This will show you a list of all the tables created in the database.<\/p>\n<p><strong>5)<\/strong> Select the tables you want to export, leave the other options unchanged and click on the &#8220;<strong>Go<\/strong>&#8221; button to proceed.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This tutorial assumes you&#8217;ve already logged into phpMyAdmin. If you are not logged in just follow the steps in\u00a0this tutorial\u00a0to\u00a0login. 1) Click the database you wish to export, in this example we&#8217;ll use the chemiclo_demo database. 2) Next, click on the &#8220;Export&#8221; tab and select the format in which you&#8230;<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"ht-kb-category":[38],"ht-kb-tag":[122,129,50,124],"class_list":["post-453","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-mysql","ht_kb_tag-database","ht_kb_tag-export","ht_kb_tag-mysql","ht_kb_tag-phpmyadmin"],"_links":{"self":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/453","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/comments?post=453"}],"version-history":[{"count":3,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/453\/revisions"}],"predecessor-version":[{"id":2123,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/453\/revisions\/2123"}],"wp:attachment":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/media?parent=453"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=453"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=453"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}