{"id":2905,"date":"2016-12-12T06:17:34","date_gmt":"2016-12-12T06:17:34","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=2905"},"modified":"2023-08-03T08:26:08","modified_gmt":"2023-08-03T07:26:08","slug":"learn-backup-database-cpanel","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-backup-database-cpanel\/","title":{"rendered":"Learn How to Backup your database in cPanel!"},"content":{"rendered":"

Backing up your website’s database is one of the most important activities that you should carry out periodically, as this can keep you away from headaches that can be caused because of the loss of data.<\/p>\n

Most of the application that websites run off these days, mostly have a back-end database. If something goes wrong in the database, either accidentally or if the database gets corrupted because of malicious activity, the entire database you have worked on is gone if daily backups are not taken.<\/p>\n

If I am making larger changes on my website or upgrade to the latest version, or I just posted some great content, I go ahead and download the copy of my database backup for a better safety.<\/p>\n

Backup database in cPanel<\/h4>\n

Step 1:<\/strong> Login to your cPanel.<\/p>\n

Step 2:<\/strong> Click on BackUp that is under the files section.<\/p>\n

\"click-on-backup\"<\/a><\/p>\n

 <\/p>\n

Step 3:<\/strong> Now under the Download a MySQL Database Backup section, click on your database name, in this case, username5_wordpress.<\/p>\n

\"click-on-database-name\"<\/a><\/p>\n

Step4:<\/strong> On your local machine, go to the folder of your web-browser where the database backup is downloaded and you should now see the compressed .sql.gz file.<\/p>\n

Now have a copy of your database that is locally stored safely on your own computer. If you delete something by accident or having a database problem, you can then simply restore your database from that backup.<\/p>\n

You should also read the knowledgebase post on A Step by Step Process to Restore Home Directory Backup in cPanel<\/a>.<\/p>\n

cPanel is a user-friendly platform to work with if it is backed by the best hosting platform. If you want to migrate your website to a reliable hosting provider, check out our cPanel hosting plans<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

Backing up your website’s database is one of the most important activities that you should carry out periodically, as this can keep you away from headaches that can be caused because of the loss of data. Most of the application that websites run off these days, mostly have a back-end database. If something goes wrong […]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-2905","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-cpanel-faq"],"yoast_head":"\nLearn How to Backup your database in cPanel!<\/title>\n<meta name=\"description\" content=\"Learn how to easily back up your database in cPanel with this simple step-by-step tutorial. Protect your valuable data and ensure peace of mind with regular database backups, all in just a few straightforward steps.\" \/>\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.milesweb.co.uk\/hosting-faqs\/learn-backup-database-cpanel\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Learn How to Backup your database in cPanel!\" \/>\n<meta property=\"og:description\" content=\"Learn how to easily back up your database in cPanel with this simple step-by-step tutorial. Protect your valuable data and ensure peace of mind with regular database backups, all in just a few straightforward steps.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-backup-database-cpanel\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2016-12-12T06:17:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-03T07:26:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/click-on-backup.png\" \/>\n<meta name=\"author\" content=\"Pravin Ganore\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pravin Ganore\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-backup-database-cpanel\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-backup-database-cpanel\/\",\"name\":\"Learn How to Backup your database in cPanel!\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-backup-database-cpanel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-backup-database-cpanel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/click-on-backup.png\",\"datePublished\":\"2016-12-12T06:17:34+00:00\",\"dateModified\":\"2023-08-03T07:26:08+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/9f6aad74f4af57132ba60117b4ab3ea6\"},\"description\":\"Learn how to easily back up your database in cPanel with this simple step-by-step tutorial. Protect your valuable data and ensure peace of mind with regular database backups, all in just a few straightforward steps.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-backup-database-cpanel\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-backup-database-cpanel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-backup-database-cpanel\/#primaryimage\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/click-on-backup.png\",\"contentUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/click-on-backup.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-backup-database-cpanel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Learn How to Backup your database in cPanel!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/9f6aad74f4af57132ba60117b4ab3ea6\",\"name\":\"Pravin Ganore\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0cc3f850bd88b8c03fef8afc4399e314?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0cc3f850bd88b8c03fef8afc4399e314?s=96&d=blank&r=g\",\"caption\":\"Pravin Ganore\"},\"description\":\"Pravin is Journalist Specializing in Blogging, Social Networking and Community Management. As a constant learner, he is always aiming towards new ideas and greater knowledge. When he is not doing research, reading, or writing for blogs, you can find him hanging around social media sites.\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/pravin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Learn How to Backup your database in cPanel!","description":"Learn how to easily back up your database in cPanel with this simple step-by-step tutorial. Protect your valuable data and ensure peace of mind with regular database backups, all in just a few straightforward steps.","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.milesweb.co.uk\/hosting-faqs\/learn-backup-database-cpanel\/","og_locale":"en_GB","og_type":"article","og_title":"Learn How to Backup your database in cPanel!","og_description":"Learn how to easily back up your database in cPanel with this simple step-by-step tutorial. Protect your valuable data and ensure peace of mind with regular database backups, all in just a few straightforward steps.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-backup-database-cpanel\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2016-12-12T06:17:34+00:00","article_modified_time":"2023-08-03T07:26:08+00:00","og_image":[{"url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/click-on-backup.png","type":"","width":"","height":""}],"author":"Pravin Ganore","twitter_misc":{"Written by":"Pravin Ganore","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-backup-database-cpanel\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-backup-database-cpanel\/","name":"Learn How to Backup your database in cPanel!","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-backup-database-cpanel\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-backup-database-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/click-on-backup.png","datePublished":"2016-12-12T06:17:34+00:00","dateModified":"2023-08-03T07:26:08+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/9f6aad74f4af57132ba60117b4ab3ea6"},"description":"Learn how to easily back up your database in cPanel with this simple step-by-step tutorial. Protect your valuable data and ensure peace of mind with regular database backups, all in just a few straightforward steps.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-backup-database-cpanel\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-backup-database-cpanel\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-backup-database-cpanel\/#primaryimage","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/click-on-backup.png","contentUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/click-on-backup.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-backup-database-cpanel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"Learn How to Backup your database in cPanel!"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/9f6aad74f4af57132ba60117b4ab3ea6","name":"Pravin Ganore","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0cc3f850bd88b8c03fef8afc4399e314?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0cc3f850bd88b8c03fef8afc4399e314?s=96&d=blank&r=g","caption":"Pravin Ganore"},"description":"Pravin is Journalist Specializing in Blogging, Social Networking and Community Management. As a constant learner, he is always aiming towards new ideas and greater knowledge. When he is not doing research, reading, or writing for blogs, you can find him hanging around social media sites.","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/pravin\/"}]}},"views":1494,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/2905","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=2905"}],"version-history":[{"count":2,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/2905\/revisions"}],"predecessor-version":[{"id":14943,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/2905\/revisions\/14943"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=2905"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=2905"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=2905"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}