{"id":42913,"date":"2019-05-29T13:13:49","date_gmt":"2019-05-29T17:13:49","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/?p=42913"},"modified":"2023-12-15T10:42:42","modified_gmt":"2023-12-15T15:42:42","slug":"how-to-restore-a-database-with-backup-manager","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/product-guides\/backup-manager\/how-to-restore-a-database-with-backup-manager\/","title":{"rendered":"How to Restore a Database With Backup Manager"},"content":{"rendered":"\n<p><strong>InMotion Hosting&#8217;s Backup Manager<\/strong> for automated backups has an option to restore databases separately from <a href=\"\/support\/website\/how-to-restore-a-backup-file-folder\/\">files and folders<\/a>. This is similar to restoring backups with cPanel MySQL Databases  Below we cover how to <strong>restore a backup with cPanel Backup Manager<\/strong>.<\/p>\n\n\n\n<p><strong>Note:<\/strong> The Backup Manager is a different tool than <a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/cpanel-backups\/\">cPanel Backup and Backup Wizard<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Restore a Database<\/h2>\n\n\n\n<ol class=\"article_list wp-block-list\">\n<li><a href=\"\/support\/edu\/cpanel\/how-to-log-into-cpanel\/\">Log into cPanel<\/a>.<\/li>\n\n\n\n<li>Click on <strong>Backup Manager<\/strong>.<\/li>\n\n\n\n<li>Click on <strong><em class=\"icon-play\"> <\/em>MySQL<\/strong> <em>(or PgSQL)<\/em>.<\/li>\n\n\n\n<li>Select a <strong>Restore From Date<\/strong>.<\/li>\n\n\n\n<li>Select a <strong>Database<\/strong>.<\/li>\n\n\n\n<li>Select the <strong>Restore to a different folder<\/strong> or <strong>Dump current database to path above and overwrite current database with the backup <\/strong>.<\/li>\n\n\n\n<li>Type the name of a directory you would like to use as the <b>Dump Path<\/b>.\n    <br><p class=\"alert alert-danger\" role=\"alert\"><strong>Warning:<\/strong> Ensure the folder <strong>doesn&#8217;t already exist<\/strong> to prevent data loss.<\/p><\/li>\n\n\n\n<li>Select the option <em>Dump backup to path above<\/em>.<\/li>\n\n\n\n<li>Click <strong>Restore<\/strong>.<\/li>\n<\/ol>\n\n\n\n<p>You can request more disk space for Backup Manager from the <a href=\"\/support\/website\/how-to-add-storage-for-data-backups-using-the-amp-marketplace\/\">Account Management Panel (AMP) Marketplace<\/a>. WordPress users should check out our <a href=\"\/support\/edu\/wordpress\/plugins\/recommended-wordpress-backup-plugins\/\">recommended WordPress backup plugins<\/a>.<\/p>\n\n\n\n<p>Remember, backups are but a layer to overall web security. For enhanced overall website security, consider the following:\n  <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Security plugin(s) for your content management system (CMS) &#8211; <em><a href=\"\/support\/edu\/wordpress\/plugins\/recommended-security-plugins\/\">WordPress<\/a>, <a href=\"\/support\/website\/security-info-plugin\/\">Matomo<\/a>, etc.<\/em><\/li>\n\n\n\n<li>Up-to-date <a href=\"\/support\/website\/how-to-change-the-php-version-your-account-uses\/\">PHP version<\/a><\/li>\n\n\n\n<li>Enable features to <a href=\"\/support\/email\/strengthen-overall-email-authentication\/\">strengthen overall email authentication<\/a><\/li>\n\n\n\n<li>Consider using <a href=\"https:\/\/www.inmotionhosting.com\/support\/security\/monarx-security\/\">Monarx<\/a> for greater security<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>InMotion Hosting&#8217;s Backup Manager for automated backups has an option to restore databases separately from files and folders. This is similar to restoring backups with cPanel MySQL Databases Below we cover how to restore a backup with cPanel Backup Manager. Note: The Backup Manager is a different tool than cPanel Backup and Backup Wizard. Restore<a class=\"moretag\" href=\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/backup-manager\/how-to-restore-a-database-with-backup-manager\/\"> Read More ><\/a><\/p>\n","protected":false},"author":57014,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4416],"tags":[],"class_list":["post-42913","post","type-post","status-publish","format-standard","hentry","category-backup-manager"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Restore a Database with Backup Manager<\/title>\n<meta name=\"description\" content=\"Learn how to restore a database with Backup Manager.\" \/>\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.inmotionhosting.com\/support\/product-guides\/backup-manager\/how-to-restore-a-database-with-backup-manager\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Restore a Database with Backup Manager\" \/>\n<meta property=\"og:description\" content=\"Learn how to restore a database with Backup Manager.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/backup-manager\/how-to-restore-a-database-with-backup-manager\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-29T17:13:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-15T15:42:42+00:00\" \/>\n<meta name=\"author\" content=\"InMotion Hosting Contributor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"InMotion Hosting Contributor\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/backup-manager\/how-to-restore-a-database-with-backup-manager\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/backup-manager\/how-to-restore-a-database-with-backup-manager\/\"},\"author\":{\"name\":\"InMotion Hosting Contributor\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644\"},\"headline\":\"How to Restore a Database With Backup Manager\",\"datePublished\":\"2019-05-29T17:13:49+00:00\",\"dateModified\":\"2023-12-15T15:42:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/backup-manager\/how-to-restore-a-database-with-backup-manager\/\"},\"wordCount\":217,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"articleSection\":[\"Backup Manager\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/backup-manager\/how-to-restore-a-database-with-backup-manager\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/backup-manager\/how-to-restore-a-database-with-backup-manager\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/backup-manager\/how-to-restore-a-database-with-backup-manager\/\",\"name\":\"How to Restore a Database with Backup Manager\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"datePublished\":\"2019-05-29T17:13:49+00:00\",\"dateModified\":\"2023-12-15T15:42:42+00:00\",\"description\":\"Learn how to restore a database with Backup Manager.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/backup-manager\/how-to-restore-a-database-with-backup-manager\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/backup-manager\/how-to-restore-a-database-with-backup-manager\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/product-guides\/backup-manager\/how-to-restore-a-database-with-backup-manager\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Restore a Database With Backup Manager\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support &amp; Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644\",\"name\":\"InMotion Hosting Contributor\",\"description\":\"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!\",\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/inmotion-hosting\/\",\"https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting\"],\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/inmotion-hosting-contributor\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Restore a Database with Backup Manager","description":"Learn how to restore a database with Backup Manager.","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.inmotionhosting.com\/support\/product-guides\/backup-manager\/how-to-restore-a-database-with-backup-manager\/","og_locale":"en_US","og_type":"article","og_title":"How to Restore a Database with Backup Manager","og_description":"Learn how to restore a database with Backup Manager.","og_url":"https:\/\/www.inmotionhosting.com\/support\/product-guides\/backup-manager\/how-to-restore-a-database-with-backup-manager\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2019-05-29T17:13:49+00:00","article_modified_time":"2023-12-15T15:42:42+00:00","author":"InMotion Hosting Contributor","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"InMotion Hosting Contributor","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/product-guides\/backup-manager\/how-to-restore-a-database-with-backup-manager\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/product-guides\/backup-manager\/how-to-restore-a-database-with-backup-manager\/"},"author":{"name":"InMotion Hosting Contributor","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644"},"headline":"How to Restore a Database With Backup Manager","datePublished":"2019-05-29T17:13:49+00:00","dateModified":"2023-12-15T15:42:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/product-guides\/backup-manager\/how-to-restore-a-database-with-backup-manager\/"},"wordCount":217,"commentCount":2,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"articleSection":["Backup Manager"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/product-guides\/backup-manager\/how-to-restore-a-database-with-backup-manager\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/product-guides\/backup-manager\/how-to-restore-a-database-with-backup-manager\/","url":"https:\/\/www.inmotionhosting.com\/support\/product-guides\/backup-manager\/how-to-restore-a-database-with-backup-manager\/","name":"How to Restore a Database with Backup Manager","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"datePublished":"2019-05-29T17:13:49+00:00","dateModified":"2023-12-15T15:42:42+00:00","description":"Learn how to restore a database with Backup Manager.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/product-guides\/backup-manager\/how-to-restore-a-database-with-backup-manager\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/product-guides\/backup-manager\/how-to-restore-a-database-with-backup-manager\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/product-guides\/backup-manager\/how-to-restore-a-database-with-backup-manager\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to Restore a Database With Backup Manager"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support &amp; Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644","name":"InMotion Hosting Contributor","description":"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!","sameAs":["https:\/\/www.linkedin.com\/company\/inmotion-hosting\/","https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting"],"url":"https:\/\/www.inmotionhosting.com\/support\/author\/inmotion-hosting-contributor\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":{"id":4416,"name":"Backup Manager","slug":"backup-manager","link":"https:\/\/www.inmotionhosting.com\/support\/product-guides\/backup-manager\/"},"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/42913","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/57014"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=42913"}],"version-history":[{"count":7,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/42913\/revisions"}],"predecessor-version":[{"id":108423,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/42913\/revisions\/108423"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=42913"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=42913"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=42913"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}