{"id":467,"date":"2017-02-19T14:48:42","date_gmt":"2017-02-19T14:48:42","guid":{"rendered":"https:\/\/chemicloud.com\/kb\/?post_type=article&#038;p=467"},"modified":"2020-03-26T01:30:14","modified_gmt":"2020-03-26T01:30:14","slug":"download-restore-mysql-database-backup","status":"publish","type":"ht_kb","link":"https:\/\/chemicloud.com\/kb\/article\/download-restore-mysql-database-backup\/","title":{"rendered":"How to Download and Restore a MySQL Database Backup"},"content":{"rendered":"<h3 id=\"how-to-download-a-mysql-database-backup\">How to download a MySQL Database Backup<\/h3>\n<p>The cPanel backup interface allows you to generate and download a backup of your MySQL databases. Backing up your website&#8217;s database periodically is always recommended, as it can save you from a lot of pain in case anything happens with your data. It is often necessary to take a backup (or \u201cdump\u201d) of an entire database management system along with all databases and tables, including the system databases which hold the users, permissions, and passwords.<\/p>\n<p><strong>1)<\/strong>\u00a0<a style=\"color: #2a94e5; box-sizing: border-box; text-decoration: none; outline: none; background: none; line-height: 1; display: inline-block;\" href=\"https:\/\/chemicloud.com\/kb\/article\/login-cpanel-whm-account\/\" target=\"_blank\" rel=\"noopener noreferrer\">Log into cPanel<\/a>.<\/p>\n<p><strong>2)<\/strong>\u00a0Look for the &#8220;<strong>Files<\/strong>&#8221; section and click on the\u00a0<strong>&#8220;Backup&#8221;\u00a0<\/strong>icon.<\/p>\n<p><img decoding=\"async\" style=\"height: 100%; width: 100%;\" src=\"https:\/\/chemicloud.com\/updata\/_editor\/images\/full_backup_cpanel.png\" alt=\"mysql backup cpanel\" \/><\/p>\n<p><strong>3)<\/strong>\u00a0In the\u00a0<strong>&#8220;Partial Backup&#8221;<\/strong>\u00a0section under &#8220;<strong>Download a MySQL Database Backup &#8220;<\/strong>\u00a0click on your database name you want to backup, in this case, it&#8217;s <strong>chemiclo_demo <\/strong>and the download will start automatically.<\/p>\n<p><strong><img decoding=\"async\" style=\"height: 100%; width: 100%;\" src=\"https:\/\/chemicloud.com\/updata\/_editor\/images\/cpanel_mysql_backup.png\" alt=\"cpanel mysql backup\" \/><\/strong><\/p>\n<p>A copy of the database will now to saved on your PC, and you should now see the compressed .sql.gz file in the folder your web-browser downloaded it.<\/p>\n<h3 id=\"how-to-restore-a-mysql-database-backup\">How to restore a MySQL Database Backup<\/h3>\n<p>If your database is corrupted or you have removed some useful data, \u00a0restoring the database from a previous working backup might be a great option to save the day. Luckily this can easily be done by following the next steps:<\/p>\n<p><strong>1)<\/strong>\u00a0<a style=\"color: #2a94e5; box-sizing: border-box; text-decoration: none; outline: none; background: none; line-height: 1; display: inline-block;\" href=\"https:\/\/chemicloud.com\/kb\/how-to-login-into-your-cpanel-whm-account\/a7\/\">Log into cPanel<\/a>.<\/p>\n<p><strong>2)<\/strong>\u00a0Look for the &#8220;<strong>Files<\/strong>&#8221; section and click on the\u00a0<strong>&#8220;Backup&#8221;\u00a0<\/strong>icon.<\/p>\n<p><strong>3)<\/strong>\u00a0In the\u00a0<strong>&#8220;Partial Backup&#8221;<\/strong>\u00a0section click the &#8220;<strong>Choose File<\/strong>&#8221; button located under &#8220;<strong>Restore a MySQL Database Backup &#8220;<\/strong>\u00a0 and select the backup file you want to use from your PC and click &#8220;<strong>Open<\/strong>&#8220;.<\/p>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" style=\"height: 100%; width: 100%;\" src=\"https:\/\/chemicloud.com\/updata\/_editor\/images\/cpanel_restore_mysql_backup.png\" alt=\"cpanel restore mysql backup\" \/><\/p>\n<p><strong>4)<\/strong><span style=\"color: #494949; font-family: montserrat,sans-serif; font-size: 15px;\">\u00a0Now the\u00a0name of the backup file you selected should\u00a0be displayed, please double check that this is the right backup and click &#8220;<\/span><strong>Upload<\/strong><span style=\"color: #494949; font-family: montserrat,sans-serif; font-size: 15px;\">&#8220;.<\/span><\/p>\n<p><img decoding=\"async\" style=\"height: 100%; width: 100%;\" src=\"https:\/\/chemicloud.com\/updata\/_editor\/images\/restore_mysql_backup.png\" alt=\"restore mysql backup cpanel\" \/><\/p>\n<p><strong>5)<\/strong><span style=\"color: #494949; font-family: montserrat,sans-serif; font-size: 15px;\">\u00a0<\/span>A new tab will open showing you information about the restore process.<\/p>\n<p><span style=\"color: #494949; font-family: montserrat,sans-serif; font-size: 15px;\"><img decoding=\"async\" style=\"height: 100%; width: 100%;\" src=\"https:\/\/chemicloud.com\/updata\/_editor\/images\/restore_mysql_backup2.png\" alt=\"restore mysql backup\" \/><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to download a MySQL Database Backup The cPanel backup interface allows you to generate and download a backup of your MySQL databases. Backing up your website&#8217;s database periodically is always recommended, as it can save you from a lot of pain in case anything happens with your data. It&#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":[35],"ht-kb-tag":[47,48,122,50,51],"class_list":["post-467","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-backups","ht_kb_tag-backup","ht_kb_tag-cpanel","ht_kb_tag-database","ht_kb_tag-mysql","ht_kb_tag-restore"],"_links":{"self":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/467","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=467"}],"version-history":[{"count":4,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/467\/revisions"}],"predecessor-version":[{"id":2914,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/467\/revisions\/2914"}],"wp:attachment":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/media?parent=467"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=467"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=467"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}