{"id":1020,"date":"2018-05-16T14:12:08","date_gmt":"2018-05-16T14:12:08","guid":{"rendered":"https:\/\/chemicloud.com\/kb\/?post_type=article&p=1020"},"modified":"2025-12-02T10:42:23","modified_gmt":"2025-12-02T10:42:23","slug":"backup-mysql-database-in-cpanel","status":"publish","type":"ht_kb","link":"https:\/\/chemicloud.com\/kb\/article\/backup-mysql-database-in-cpanel\/","title":{"rendered":"How to Manually Backup a MySQL Database in cPanel"},"content":{"rendered":"

In this article we\u2019ll show you how to back up a MySQL database in cPanel.<\/p>\n \t\t

\r\n \t\t\t \t\t\t \t\t\t\t

\r\n \t\t\t\t\tThis tutorial applies only to VPS plans \t\t\t\t<\/p>\r\n \t\t\t \t\t\t\r\n \t\t<\/div>\r\n \t\t\n

How to Backup a MySQL Database in cPanel<\/strong><\/h3>\n

Here are the steps you need to take in order to back up a MySQL database in cPanel:<\/p>\n

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

2<\/strong>. Navigate to the Files<\/strong> section and click on Backup<\/strong>. <\/em><\/p>\n

\"\"
cPanel > Files > Backup<\/figcaption><\/figure>\n

3.<\/strong> In the next window, under the Download a MySQL Database Backup\u00a0<\/strong>click on the name of the database in order to download it.<\/p>\n

4.<\/strong> You will be prompted to save a compressed archive. Make sure you save the file in a secure location on your hard drive, preferably not on the same partition as the OS.<\/p>\n

That\u2019s all there is to it. You\u2019ve successfully backed up your database. Now you are able to recover your database in case someone accidentally deletes it, or if you wish to make changes without risking destroying your original data.<\/p>\n","protected":false},"excerpt":{"rendered":"

In this article we\u2019ll show you how to back up a MySQL database in cPanel. How to Backup a MySQL Database in cPanel Here are the steps you need to take in order to back up a MySQL database in cPanel: 1. Log in to your cPanel account. 2. Navigate…<\/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":[],"class_list":["post-1020","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-mysql"],"_links":{"self":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/1020","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=1020"}],"version-history":[{"count":8,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/1020\/revisions"}],"predecessor-version":[{"id":8642,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/1020\/revisions\/8642"}],"wp:attachment":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/media?parent=1020"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=1020"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=1020"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}