{"id":34483,"date":"2021-10-22T15:02:42","date_gmt":"2021-10-22T15:02:42","guid":{"rendered":"https:\/\/www.hostduplex.com\/kb\/?post_type=ht_kb&p=34483"},"modified":"2021-10-22T15:02:43","modified_gmt":"2021-10-22T15:02:43","slug":"how-to-export-a-mysql-database","status":"publish","type":"ht_kb","link":"https:\/\/www.hostduplex.com\/kb\/article\/how-to-export-a-mysql-database\/","title":{"rendered":"How to export a MySQL Database"},"content":{"rendered":"\n

This article will walk you through the process of downloading a MySQL database. This is useful for making personal backups or migrating your website.<\/p>\n\n\n\n

1. Log in to your cPanel account<\/p>\n\n\n\n

2. Go to phpMyAdmin. You canfin it by scrolling down to the databases section or by using the search bar on your dashboard<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

3. You will be redirected to your phpMyAdmin. To the left, you will see a list of your databases. Select the one you want to export<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

4. Click on the Export tab at the top bar<\/p>\n\n\n\n

5. Make sure to select the Custom option for Export method and your desired file format<\/p>\n\n\n\n

6. Select all tables<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

7. Select all other options based on your preferences and click Go at the bottom. A file should begin downloading automatically on your browser<\/p>\n\n\n\n

\n\n\n\n

If you are a Host Duplex customer and still have questions, please open a ticket in the\u00a0Host Duplex client portal.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

This article will walk you through the process of downloading a MySQL database. This is useful for making personal backups or migrating your website. 1. Log in to your cPanel account 2. Go to phpMyAdmin. You canfin it by scrolling down to the databases section or by using the search…<\/p>\n","protected":false},"author":2,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"ht-kb-category":[20],"ht-kb-tag":[23,142,204,139,144],"class_list":["post-34483","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-cpanel","ht_kb_tag-cpanel","ht_kb_tag-database","ht_kb_tag-export","ht_kb_tag-mysql","ht_kb_tag-phpmyadmin"],"_links":{"self":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/ht-kb\/34483","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/comments?post=34483"}],"version-history":[{"count":1,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/ht-kb\/34483\/revisions"}],"predecessor-version":[{"id":34487,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/ht-kb\/34483\/revisions\/34487"}],"wp:attachment":[{"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/media?parent=34483"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=34483"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.hostduplex.com\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=34483"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}