{"id":10426,"date":"2022-09-12T10:24:44","date_gmt":"2022-09-12T10:24:44","guid":{"rendered":"https:\/\/www.webhosting.uk.com\/kb\/?p=10426"},"modified":"2026-03-03T11:53:36","modified_gmt":"2026-03-03T11:53:36","slug":"how-to-backup-a-mysql-database-using-cpanel","status":"publish","type":"post","link":"https:\/\/www.webhosting.uk.com\/kb\/how-to-backup-a-mysql-database-using-cpanel\/","title":{"rendered":"How to backup a MySQL database using cPanel"},"content":{"rendered":"<p>This article explains how to back up a MySQL database using cPanel. Creating regular database backups ensures that your data remains safe in case the database is accidentally deleted, becomes corrupted, or becomes inconsistent due to errors or failed updates.<\/p>\n<p>If such a situation occurs, you can use a previously created backup to restore the database without permanently losing your data. Having an up-to-date backup allows you to quickly recover your website and return it to a stable working state with minimal downtime.<\/p>\n<p>Steps to back up a MySQL database using cPanel:<\/p>\n<ol>\n<li>Log in to the cPanel account.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-10427 size-full\" src=\"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2022\/08\/Pasted-40.png\" alt=\"Login to WHM \" width=\"309\" height=\"332\" srcset=\"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2022\/08\/Pasted-40.png 309w, https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2022\/08\/Pasted-40-279x300.png 279w, https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2022\/08\/Pasted-40-56x60.png 56w, https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2022\/08\/Pasted-40-140x150.png 140w\" sizes=\"auto, (max-width: 309px) 100vw, 309px\" \/><\/li>\n<li>Select the \u201cFiles\u201d section and click on the \u201cBackup\u201d sub-option.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-10429 size-full\" src=\"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2022\/08\/Pasted-42.png\" alt=\"Go to Backup\" width=\"738\" height=\"237\" srcset=\"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2022\/08\/Pasted-42.png 738w, https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2022\/08\/Pasted-42-300x96.png 300w, https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2022\/08\/Pasted-42-60x19.png 60w, https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2022\/08\/Pasted-42-150x48.png 150w\" sizes=\"auto, (max-width: 738px) 100vw, 738px\" \/><\/li>\n<li>You will enter a new page. Scroll down and come to the \u201cDownload a MySQL Database backup\u201d option.<\/li>\n<li>Select the database you wish to download.<br \/>\n<a href=\"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2022\/09\/Snag_5dc25c3f.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-22155\" src=\"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2022\/09\/Snag_5dc25c3f.png\" alt=\"cpanel\" width=\"600\" height=\"406\" srcset=\"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2022\/09\/Snag_5dc25c3f.png 788w, https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2022\/09\/Snag_5dc25c3f-300x203.png 300w, https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2022\/09\/Snag_5dc25c3f-768x519.png 768w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/a><\/li>\n<li>The compressed archive will need to be saved. It is recommended that you save the file on a separate partition from your operating system, in a secure location.<br \/>\n<a href=\"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2022\/09\/Snag_5dc3ea80.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-22156\" style=\"border: 1px solid #ccc; border-radius: 6px; padding: 4px;\" src=\"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2022\/09\/Snag_5dc3ea80.png\" alt=\"zip file\" width=\"400\" height=\"51\" srcset=\"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2022\/09\/Snag_5dc3ea80.png 594w, https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2022\/09\/Snag_5dc3ea80-300x38.png 300w\" sizes=\"auto, (max-width: 400px) 100vw, 400px\" \/><\/a><\/li>\n<\/ol>\n<p>This way, you can easily back up your MySQL database using cPanel. Additionally, you can also back up<a href=\"https:\/\/www.webhosting.uk.com\/kb\/how-to-backup-a-mysql-database-using-phpmyadmin\/\">\u00a0a MySQL database using phpMyAdmin<\/a>, which is a good way to prevent data loss.<\/p>\n<p>Hopefully, now you will be able to easily recover your database in a few simple steps. However, if you face any difficulty in doing so, you can contact our support staff.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article explains how to back up a MySQL database using cPanel. Creating regular database backups ensures that your data remains safe in case the database is accidentally deleted, becomes&hellip;<\/p>\n<p><a href=\"https:\/\/www.webhosting.uk.com\/kb\/how-to-backup-a-mysql-database-using-cpanel\/\" class=\"more-link\">Read More<\/a><\/p>\n<div class='heateorSssClear'><\/div><div  class='heateor_sss_sharing_container heateor_sss_horizontal_sharing' data-heateor-sss-href='https:\/\/www.webhosting.uk.com\/kb\/how-to-backup-a-mysql-database-using-cpanel\/'><div class='heateor_sss_sharing_title' style=\"font-weight:bold\" >Spread the love<\/div><div class=\"heateor_sss_sharing_ul\"><a aria-label=\"Facebook\" class=\"heateor_sss_facebook\" href=\"https:\/\/www.facebook.com\/sharer\/sharer.php?u=https%3A%2F%2Fwww.webhosting.uk.com%2Fkb%2Fhow-to-backup-a-mysql-database-using-cpanel%2F\" title=\"Facebook\" rel=\"nofollow noopener\" target=\"_blank\" style=\"font-size:32px!important;box-shadow:none;display:inline-block;vertical-align:middle\"><span class=\"heateor_sss_svg\" style=\"background-color:#0765FE;width:40px;height:40px;display:inline-block;opacity:1;float:left;font-size:32px;box-shadow:none;display:inline-block;font-size:16px;padding:0 4px;vertical-align:middle;background-repeat:repeat;overflow:hidden;padding:0;cursor:pointer;box-sizing:content-box\"><svg style=\"display:block;\" focusable=\"false\" aria-hidden=\"true\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"100%\" height=\"100%\" viewBox=\"0 0 32 32\"><path fill=\"#fff\" d=\"M28 16c0-6.627-5.373-12-12-12S4 9.373 4 16c0 5.628 3.875 10.35 9.101 11.647v-7.98h-2.474V16H13.1v-1.58c0-4.085 1.849-5.978 5.859-5.978.76 0 2.072.15 2.608.298v3.325c-.283-.03-.775-.045-1.386-.045-1.967 0-2.728.745-2.728 2.683V16h3.92l-.673 3.667h-3.247v8.245C23.395 27.195 28 22.135 28 16Z\"><\/path><\/svg><\/span><\/a><a aria-label=\"X\" class=\"heateor_sss_button_x\" href=\"https:\/\/twitter.com\/intent\/tweet?text=How%20to%20backup%20a%20MySQL%20database%20using%20cPanel&url=https%3A%2F%2Fwww.webhosting.uk.com%2Fkb%2Fhow-to-backup-a-mysql-database-using-cpanel%2F\" title=\"X\" rel=\"nofollow noopener\" target=\"_blank\" style=\"font-size:32px!important;box-shadow:none;display:inline-block;vertical-align:middle\"><span class=\"heateor_sss_svg heateor_sss_s__default heateor_sss_s_x\" style=\"background-color:#2a2a2a;width:40px;height:40px;display:inline-block;opacity:1;float:left;font-size:32px;box-shadow:none;display:inline-block;font-size:16px;padding:0 4px;vertical-align:middle;background-repeat:repeat;overflow:hidden;padding:0;cursor:pointer;box-sizing:content-box\"><svg width=\"100%\" height=\"100%\" style=\"display:block;\" focusable=\"false\" aria-hidden=\"true\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 32 32\"><path fill=\"#fff\" d=\"M21.751 7h3.067l-6.7 7.658L26 25.078h-6.172l-4.833-6.32-5.531 6.32h-3.07l7.167-8.19L6 7h6.328l4.37 5.777L21.75 7Zm-1.076 16.242h1.7L11.404 8.74H9.58l11.094 14.503Z\"><\/path><\/svg><\/span><\/a><a aria-label=\"Linkedin\" class=\"heateor_sss_button_linkedin\" href=\"https:\/\/www.linkedin.com\/sharing\/share-offsite\/?url=https%3A%2F%2Fwww.webhosting.uk.com%2Fkb%2Fhow-to-backup-a-mysql-database-using-cpanel%2F\" title=\"Linkedin\" rel=\"nofollow noopener\" target=\"_blank\" style=\"font-size:32px!important;box-shadow:none;display:inline-block;vertical-align:middle\"><span class=\"heateor_sss_svg heateor_sss_s__default heateor_sss_s_linkedin\" style=\"background-color:#0077b5;width:40px;height:40px;display:inline-block;opacity:1;float:left;font-size:32px;box-shadow:none;display:inline-block;font-size:16px;padding:0 4px;vertical-align:middle;background-repeat:repeat;overflow:hidden;padding:0;cursor:pointer;box-sizing:content-box\"><svg style=\"display:block;\" focusable=\"false\" aria-hidden=\"true\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"100%\" height=\"100%\" viewBox=\"0 0 32 32\"><path d=\"M6.227 12.61h4.19v13.48h-4.19V12.61zm2.095-6.7a2.43 2.43 0 0 1 0 4.86c-1.344 0-2.428-1.09-2.428-2.43s1.084-2.43 2.428-2.43m4.72 6.7h4.02v1.84h.058c.56-1.058 1.927-2.176 3.965-2.176 4.238 0 5.02 2.792 5.02 6.42v7.395h-4.183v-6.56c0-1.564-.03-3.574-2.178-3.574-2.18 0-2.514 1.7-2.514 3.46v6.668h-4.187V12.61z\" fill=\"#fff\"><\/path><\/svg><\/span><\/a><\/div><div class=\"heateorSssClear\"><\/div><\/div><div class='heateorSssClear'><\/div>","protected":false},"author":28,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1322],"tags":[],"class_list":["post-10426","post","type-post","status-publish","format-standard","hentry","category-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.7 (Yoast SEO v27.7) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to Create a MySQL Database Backup in cPanel<\/title>\n<meta name=\"description\" content=\"Learn how to back up a MySQL database using cPanel. Follow our simple guide for easy backups to enhanced data protection.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.webhosting.uk.com\/kb\/how-to-backup-a-mysql-database-using-cpanel\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to backup a MySQL database using cPanel\" \/>\n<meta property=\"og:description\" content=\"Learn how to back up a MySQL database using cPanel. Follow our simple guide for easy backups to enhanced data protection.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.webhosting.uk.com\/kb\/how-to-backup-a-mysql-database-using-cpanel\/\" \/>\n<meta property=\"og:site_name\" content=\"Webhosting UK Knowledge Base\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webhostingukcom\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-12T10:24:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-03T11:53:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2022\/08\/Pasted-40.png\" \/>\n\t<meta property=\"og:image:width\" content=\"309\" \/>\n\t<meta property=\"og:image:height\" content=\"332\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Victor G\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@WebhostingUKcom\" \/>\n<meta name=\"twitter:site\" content=\"@WebhostingUKcom\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/how-to-backup-a-mysql-database-using-cpanel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/how-to-backup-a-mysql-database-using-cpanel\\\/\"},\"author\":{\"name\":\"Victor G\",\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/#\\\/schema\\\/person\\\/ea067684eae84c2b8b49a81c69407297\"},\"headline\":\"How to backup a MySQL database using cPanel\",\"datePublished\":\"2022-09-12T10:24:44+00:00\",\"dateModified\":\"2026-03-03T11:53:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/how-to-backup-a-mysql-database-using-cpanel\\\/\"},\"wordCount\":232,\"publisher\":{\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/how-to-backup-a-mysql-database-using-cpanel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/Pasted-40.png\",\"articleSection\":[\"MySQL\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/how-to-backup-a-mysql-database-using-cpanel\\\/\",\"url\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/how-to-backup-a-mysql-database-using-cpanel\\\/\",\"name\":\"How to Create a MySQL Database Backup in cPanel\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/how-to-backup-a-mysql-database-using-cpanel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/how-to-backup-a-mysql-database-using-cpanel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/Pasted-40.png\",\"datePublished\":\"2022-09-12T10:24:44+00:00\",\"dateModified\":\"2026-03-03T11:53:36+00:00\",\"description\":\"Learn how to back up a MySQL database using cPanel. Follow our simple guide for easy backups to enhanced data protection.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/how-to-backup-a-mysql-database-using-cpanel\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/how-to-backup-a-mysql-database-using-cpanel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/how-to-backup-a-mysql-database-using-cpanel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/Pasted-40.png\",\"contentUrl\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/Pasted-40.png\",\"width\":309,\"height\":332,\"caption\":\"cPanel Log in\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/how-to-backup-a-mysql-database-using-cpanel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to backup a MySQL database using cPanel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/#website\",\"url\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/\",\"name\":\"Webhosting UK Knowledge Base\",\"description\":\"Expert Insights on Hosting, Development, Security, Marketing, and SEO\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/#organization\"},\"alternateName\":\"WHUK\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/#organization\",\"name\":\"Webhosting UK\",\"alternateName\":\"WHUK\",\"url\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/WHUK-logo-1.png\",\"contentUrl\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/WHUK-logo-1.png\",\"width\":1200,\"height\":628,\"caption\":\"Webhosting UK\"},\"image\":{\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/webhostingukcom\",\"https:\\\/\\\/x.com\\\/WebhostingUKcom\",\"https:\\\/\\\/www.youtube.com\\\/c\\\/webhostinguk\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/webhosting-uk-com-ltd\\\/\",\"https:\\\/\\\/www.instagram.com\\\/webhosting_uk\\\/\",\"https:\\\/\\\/www.tiktok.com\\\/@webhostinguk\"],\"description\":\"Fast, reliable, and cost-effective website hosting services with Webhosting UK. Committed to providing you secure support around the clock.\",\"email\":\"sales@webhosting.uk.com\",\"telephone\":\"0800 862 0890\",\"legalName\":\"Webhosting UK\",\"foundingDate\":\"2001-02-07\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"51\",\"maxValue\":\"200\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.webhosting.uk.com\\\/kb\\\/#\\\/schema\\\/person\\\/ea067684eae84c2b8b49a81c69407297\",\"name\":\"Victor G\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/9bf0713adcbaded4878508c93d93927ecbfa4f74548fd9bcee41478d8768bd66?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/9bf0713adcbaded4878508c93d93927ecbfa4f74548fd9bcee41478d8768bd66?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/9bf0713adcbaded4878508c93d93927ecbfa4f74548fd9bcee41478d8768bd66?s=96&d=mm&r=g\",\"caption\":\"Victor G\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Create a MySQL Database Backup in cPanel","description":"Learn how to back up a MySQL database using cPanel. Follow our simple guide for easy backups to enhanced data protection.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.webhosting.uk.com\/kb\/how-to-backup-a-mysql-database-using-cpanel\/","og_locale":"en_GB","og_type":"article","og_title":"How to backup a MySQL database using cPanel","og_description":"Learn how to back up a MySQL database using cPanel. Follow our simple guide for easy backups to enhanced data protection.","og_url":"https:\/\/www.webhosting.uk.com\/kb\/how-to-backup-a-mysql-database-using-cpanel\/","og_site_name":"Webhosting UK Knowledge Base","article_publisher":"https:\/\/www.facebook.com\/webhostingukcom","article_published_time":"2022-09-12T10:24:44+00:00","article_modified_time":"2026-03-03T11:53:36+00:00","og_image":[{"width":309,"height":332,"url":"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2022\/08\/Pasted-40.png","type":"image\/png"}],"author":"Victor G","twitter_card":"summary_large_image","twitter_creator":"@WebhostingUKcom","twitter_site":"@WebhostingUKcom","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.webhosting.uk.com\/kb\/how-to-backup-a-mysql-database-using-cpanel\/#article","isPartOf":{"@id":"https:\/\/www.webhosting.uk.com\/kb\/how-to-backup-a-mysql-database-using-cpanel\/"},"author":{"name":"Victor G","@id":"https:\/\/www.webhosting.uk.com\/kb\/#\/schema\/person\/ea067684eae84c2b8b49a81c69407297"},"headline":"How to backup a MySQL database using cPanel","datePublished":"2022-09-12T10:24:44+00:00","dateModified":"2026-03-03T11:53:36+00:00","mainEntityOfPage":{"@id":"https:\/\/www.webhosting.uk.com\/kb\/how-to-backup-a-mysql-database-using-cpanel\/"},"wordCount":232,"publisher":{"@id":"https:\/\/www.webhosting.uk.com\/kb\/#organization"},"image":{"@id":"https:\/\/www.webhosting.uk.com\/kb\/how-to-backup-a-mysql-database-using-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2022\/08\/Pasted-40.png","articleSection":["MySQL"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/www.webhosting.uk.com\/kb\/how-to-backup-a-mysql-database-using-cpanel\/","url":"https:\/\/www.webhosting.uk.com\/kb\/how-to-backup-a-mysql-database-using-cpanel\/","name":"How to Create a MySQL Database Backup in cPanel","isPartOf":{"@id":"https:\/\/www.webhosting.uk.com\/kb\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.webhosting.uk.com\/kb\/how-to-backup-a-mysql-database-using-cpanel\/#primaryimage"},"image":{"@id":"https:\/\/www.webhosting.uk.com\/kb\/how-to-backup-a-mysql-database-using-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2022\/08\/Pasted-40.png","datePublished":"2022-09-12T10:24:44+00:00","dateModified":"2026-03-03T11:53:36+00:00","description":"Learn how to back up a MySQL database using cPanel. Follow our simple guide for easy backups to enhanced data protection.","breadcrumb":{"@id":"https:\/\/www.webhosting.uk.com\/kb\/how-to-backup-a-mysql-database-using-cpanel\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.webhosting.uk.com\/kb\/how-to-backup-a-mysql-database-using-cpanel\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.webhosting.uk.com\/kb\/how-to-backup-a-mysql-database-using-cpanel\/#primaryimage","url":"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2022\/08\/Pasted-40.png","contentUrl":"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2022\/08\/Pasted-40.png","width":309,"height":332,"caption":"cPanel Log in"},{"@type":"BreadcrumbList","@id":"https:\/\/www.webhosting.uk.com\/kb\/how-to-backup-a-mysql-database-using-cpanel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.webhosting.uk.com\/kb\/"},{"@type":"ListItem","position":2,"name":"How to backup a MySQL database using cPanel"}]},{"@type":"WebSite","@id":"https:\/\/www.webhosting.uk.com\/kb\/#website","url":"https:\/\/www.webhosting.uk.com\/kb\/","name":"Webhosting UK Knowledge Base","description":"Expert Insights on Hosting, Development, Security, Marketing, and SEO","publisher":{"@id":"https:\/\/www.webhosting.uk.com\/kb\/#organization"},"alternateName":"WHUK","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.webhosting.uk.com\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/www.webhosting.uk.com\/kb\/#organization","name":"Webhosting UK","alternateName":"WHUK","url":"https:\/\/www.webhosting.uk.com\/kb\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.webhosting.uk.com\/kb\/#\/schema\/logo\/image\/","url":"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2023\/08\/WHUK-logo-1.png","contentUrl":"https:\/\/www.webhosting.uk.com\/kb\/wp-content\/uploads\/2023\/08\/WHUK-logo-1.png","width":1200,"height":628,"caption":"Webhosting UK"},"image":{"@id":"https:\/\/www.webhosting.uk.com\/kb\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webhostingukcom","https:\/\/x.com\/WebhostingUKcom","https:\/\/www.youtube.com\/c\/webhostinguk","https:\/\/www.linkedin.com\/company\/webhosting-uk-com-ltd\/","https:\/\/www.instagram.com\/webhosting_uk\/","https:\/\/www.tiktok.com\/@webhostinguk"],"description":"Fast, reliable, and cost-effective website hosting services with Webhosting UK. Committed to providing you secure support around the clock.","email":"sales@webhosting.uk.com","telephone":"0800 862 0890","legalName":"Webhosting UK","foundingDate":"2001-02-07","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"51","maxValue":"200"}},{"@type":"Person","@id":"https:\/\/www.webhosting.uk.com\/kb\/#\/schema\/person\/ea067684eae84c2b8b49a81c69407297","name":"Victor G","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/9bf0713adcbaded4878508c93d93927ecbfa4f74548fd9bcee41478d8768bd66?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/9bf0713adcbaded4878508c93d93927ecbfa4f74548fd9bcee41478d8768bd66?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9bf0713adcbaded4878508c93d93927ecbfa4f74548fd9bcee41478d8768bd66?s=96&d=mm&r=g","caption":"Victor G"}}]}},"_links":{"self":[{"href":"https:\/\/www.webhosting.uk.com\/kb\/wp-json\/wp\/v2\/posts\/10426","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.webhosting.uk.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.webhosting.uk.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.webhosting.uk.com\/kb\/wp-json\/wp\/v2\/users\/28"}],"replies":[{"embeddable":true,"href":"https:\/\/www.webhosting.uk.com\/kb\/wp-json\/wp\/v2\/comments?post=10426"}],"version-history":[{"count":12,"href":"https:\/\/www.webhosting.uk.com\/kb\/wp-json\/wp\/v2\/posts\/10426\/revisions"}],"predecessor-version":[{"id":22157,"href":"https:\/\/www.webhosting.uk.com\/kb\/wp-json\/wp\/v2\/posts\/10426\/revisions\/22157"}],"wp:attachment":[{"href":"https:\/\/www.webhosting.uk.com\/kb\/wp-json\/wp\/v2\/media?parent=10426"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.webhosting.uk.com\/kb\/wp-json\/wp\/v2\/categories?post=10426"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.webhosting.uk.com\/kb\/wp-json\/wp\/v2\/tags?post=10426"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}