{"id":2916,"date":"2016-12-16T10:52:56","date_gmt":"2016-12-16T10:52:56","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=2916"},"modified":"2023-02-06T06:50:16","modified_gmt":"2023-02-06T06:50:16","slug":"step-step-process-restore-database-backup-cpanel","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/step-step-process-restore-database-backup-cpanel\/","title":{"rendered":"A Step by Step Process to Restore a Database Backup in cPanel"},"content":{"rendered":"<p>In this knowledge-base post, we will learn how to restore the MySQL database from a database backup within cPanel.<\/p>\n<p>If you accidentally deleted some data from your website&#8217;s database, or the database got corrupted due to some reason, restoring the database to a previously backed up state is a great option that can save your time and hassle.<\/p>\n<p>Of course, you will need to already have a database backup to restore. It is always a good move to keep the database backup prior to any big site changes, or just prior to upgrading to the latest version of software that runs the website.<\/p>\n<h4>Restore database backup in cPanel<\/h4>\n<p><strong>Step 1:<\/strong> Login to your cPanel.&nbsp;(Can take cPanels live demo <a href=\"https:\/\/karma.solidhosting.pro:2083\/\" target=\"_blank\" rel=\"nofollow noopener\">here<\/a>&nbsp;using Username: mwdemo | Password: demomw&nbsp;for free)<\/p>\n<p><strong>Step 2:<\/strong> Click on Backup under the files section.<\/p>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/click-on-backup.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2906\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/click-on-backup.png\" alt=\"click-on-backup\" width=\"1224\" height=\"194\" srcset=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/click-on-backup.png 1224w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/click-on-backup-300x48.png 300w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/click-on-backup-768x122.png 768w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/click-on-backup-1024x162.png 1024w\" sizes=\"auto, (max-width: 1224px) 100vw, 1224px\" \/><\/a><\/p>\n<p><strong>Step 3:<\/strong> Under Restore a MySQL Database, click on Choose File.<\/p>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/choose-file-open.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2917\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/choose-file-open.png\" alt=\"choose-file-open\" width=\"788\" height=\"544\" srcset=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/choose-file-open.png 788w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/choose-file-open-300x207.png 300w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/choose-file-open-768x530.png 768w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/choose-file-open-392x272.png 392w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/choose-file-open-130x90.png 130w\" sizes=\"auto, (max-width: 788px) 100vw, 788px\" \/><\/a><\/p>\n<p>Next navigate in the file browser to your database backup you&#8217;d like to restore, click on it, then click on Open.<\/p>\n<p><strong>Step 4:<\/strong> You should now see your database backup that you&#8217;ve selected, go ahead and click Upload.<\/p>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/upload-database.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2918\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/upload-database.png\" alt=\"upload-database\" width=\"342\" height=\"115\" srcset=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/upload-database.png 342w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/upload-database-300x101.png 300w\" sizes=\"auto, (max-width: 342px) 100vw, 342px\" \/><\/a><\/p>\n<p><strong>Step 5:<\/strong> Finally, you will see the full backup that got restored, notice how it mentions our userna5_wordpress database already existed, and also it&#8217;s using the DROP TABLE IF EXISTS command.<\/p>\n<p><a href=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/cpanel-backups-database-restored.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2919\" src=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/cpanel-backups-database-restored.png\" alt=\"cpanel-backups-database-restored\" width=\"673\" height=\"471\" srcset=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/cpanel-backups-database-restored.png 673w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/cpanel-backups-database-restored-300x210.png 300w, https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/cpanel-backups-database-restored-130x90.png 130w\" sizes=\"auto, (max-width: 673px) 100vw, 673px\" \/><\/a><\/p>\n<p>Now you are done with restoring your database to a previous working version that you have backed up and has successfully brought back your missing data or allowed your site to function again properly.<\/p>\n<p>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 <a href=\"https:\/\/www.milesweb.co.uk\/hosting\/cpanel-hosting\">cPanel hosting plans<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this knowledge-base post, we will learn how to restore the MySQL database from a database backup within cPanel. If you accidentally deleted some data from your website&#8217;s database, or the database got corrupted due to some reason, restoring the database to a previously backed up state is a great option that can save your [&hellip;]<\/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-2916","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-cpanel-faq"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>A Step by Step Process to Restore a Database Backup in cPanel<\/title>\n<meta name=\"description\" content=\"In the Files section of the cPanel main page, you will find the Backup interface for restoring databases.\" \/>\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\/step-step-process-restore-database-backup-cpanel\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A Step by Step Process to Restore a Database Backup in cPanel\" \/>\n<meta property=\"og:description\" content=\"In the Files section of the cPanel main page, you will find the Backup interface for restoring databases.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/step-step-process-restore-database-backup-cpanel\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2016-12-16T10:52:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-06T06:50:16+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=\"3 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\/step-step-process-restore-database-backup-cpanel\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/step-step-process-restore-database-backup-cpanel\/\",\"name\":\"A Step by Step Process to Restore a Database Backup in cPanel\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/step-step-process-restore-database-backup-cpanel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/step-step-process-restore-database-backup-cpanel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/click-on-backup.png\",\"datePublished\":\"2016-12-16T10:52:56+00:00\",\"dateModified\":\"2023-02-06T06:50:16+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/9f6aad74f4af57132ba60117b4ab3ea6\"},\"description\":\"In the Files section of the cPanel main page, you will find the Backup interface for restoring databases.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/step-step-process-restore-database-backup-cpanel\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/step-step-process-restore-database-backup-cpanel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/step-step-process-restore-database-backup-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\/step-step-process-restore-database-backup-cpanel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"A Step by Step Process to Restore a Database Backup 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":"A Step by Step Process to Restore a Database Backup in cPanel","description":"In the Files section of the cPanel main page, you will find the Backup interface for restoring databases.","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\/step-step-process-restore-database-backup-cpanel\/","og_locale":"en_GB","og_type":"article","og_title":"A Step by Step Process to Restore a Database Backup in cPanel","og_description":"In the Files section of the cPanel main page, you will find the Backup interface for restoring databases.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/step-step-process-restore-database-backup-cpanel\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2016-12-16T10:52:56+00:00","article_modified_time":"2023-02-06T06:50:16+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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/step-step-process-restore-database-backup-cpanel\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/step-step-process-restore-database-backup-cpanel\/","name":"A Step by Step Process to Restore a Database Backup in cPanel","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/step-step-process-restore-database-backup-cpanel\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/step-step-process-restore-database-backup-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2016\/12\/click-on-backup.png","datePublished":"2016-12-16T10:52:56+00:00","dateModified":"2023-02-06T06:50:16+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/9f6aad74f4af57132ba60117b4ab3ea6"},"description":"In the Files section of the cPanel main page, you will find the Backup interface for restoring databases.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/step-step-process-restore-database-backup-cpanel\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/step-step-process-restore-database-backup-cpanel\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/step-step-process-restore-database-backup-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\/step-step-process-restore-database-backup-cpanel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"A Step by Step Process to Restore a Database Backup 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":1576,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/2916","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=2916"}],"version-history":[{"count":5,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/2916\/revisions"}],"predecessor-version":[{"id":14676,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/2916\/revisions\/14676"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=2916"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=2916"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=2916"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}