{"id":2462,"date":"2013-02-15T14:06:56","date_gmt":"2013-02-15T19:06:56","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2013\/02\/15\/342-restore-db\/"},"modified":"2022-03-11T11:11:31","modified_gmt":"2022-03-11T16:11:31","slug":"restore-database-backup-prestashop","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/","title":{"rendered":"Restoring a database backup in PrestaShop 1.5"},"content":{"rendered":"<p>After learning to <a href=\"\/support\/edu\/prestashop\/db-backup\/\">create a database backup<\/a> in your back office, you will need to understand how to restore the data case of an emergency. While it is a fairly simple process, the following tutorial demonstrates the steps to restoring an existing backup for your PrestaShop 1.5 store. The majority of this tutorial revolves around getting the backup downloaded to your computer. The last step leads you to the steps for importing the database using the phpMyAdmin tool.<\/p>\n<h2>How to restore a database backup in PrestaShop 1.5<\/h2>\n<ol class=\"article_list\">\n<li><a href=\"\/support\/edu\/prestashop\/login-to-dashboard\/\">Log into your PrestaShop back office dashboard<\/a>.<\/li>\n<li>Using the top menu bar, hover over the <strong>Advanced Parameters<\/strong> section and click on <strong>DB Backup<\/strong> from the drop-down menu that appears.<\/li>\n<li>From the <em>Advanced Parameters &gt; DB Backup<\/em> screen, scroll down until you see the following section:<br><a href=\"\/support\/wp-content\/uploads\/2013\/02\/edu_prestashop1.5_restore-db-backup_backup-list.png\" rel=\"lightbox-0\"><img decoding=\"async\" width=\"1021\" height=\"229\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/edu_prestashop1.5_restore-db-backup_backup-list.png\" class=\"optimized-lcp-image\" alt=\"list of completed backups\" loading=\"eager\" fetchpriority=\"high\" sizes=\"(max-width: 768px) 100vw, 768px\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/edu_prestashop1.5_restore-db-backup_backup-list.png 1021w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/edu_prestashop1.5_restore-db-backup_backup-list-300x67.png 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/edu_prestashop1.5_restore-db-backup_backup-list-768x172.png 768w\"><\/a>\n<div style=\"clear:both;\"><\/div>\n<p> This is a list of your previously generated backups. Remember that these backup files are not for Prestashop installation and application files, but only for the PrestaShop database.<\/p><\/li>\n<li><a href=\"\/support\/wp-content\/uploads\/2013\/02\/edu_prestashop1.5_restore-db-backup_save-option.png\" rel=\"lightbox-0\"><img loading=\"lazy\" decoding=\"async\" alt=\"view or save option\" class=\"std_ss\" height=\"321\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/edu_prestashop1.5_restore-db-backup_save-option.png\" style=\"margin: 0px 0px 15px 15px; float: right;\" width=\"448\"><\/a>\n<div style=\"clear:both;\"><\/div>\n<p>To download the backup click on the View icon for the backup you wish to work with. This will bring up a popup with the option to Open or Save the backup. Click on the <strong>Save<\/strong> button to download it to your local machine.<\/p><\/li>\n<li>When downloading the file, ensure you know which folder you are using for downloads. This is important so that you will be able to easily find it for importing.<\/li>\n<li>Now that you have the database backup on your local machine, you simply need to <a href=\"\/support\/server\/databases\/import-database-using-phpmyadmin\/\">import the backup using the phpMyAdmin<\/a> tool in cPanel. You will need to <a href=\"\/support\/edu\/prestashop\/341-find-database-name\/\" target=\"_blank\" rel=\"noopener\">find the database name<\/a> that your PrestaShop store uses. Once you complete this step, the file will be imported and your database restored.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>After learning to create a database backup in your back office, you will need to understand how to restore the data case of an emergency. While it is a fairly simple process, the following tutorial demonstrates the steps to restoring an existing backup for your PrestaShop 1.5 store. The majority of this tutorial revolves around<a class=\"moretag\" href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/\"> Read More ><\/a><\/p>\n","protected":false},"author":8,"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":[92],"tags":[],"class_list":["post-2462","post","type-post","status-publish","format-standard","hentry","category-prestashop"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Restoring a database backup in PrestaShop 1.5 | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"Need to restore a database backup for your store? Learn how in this PrestaShop 1.5 tutorial.\" \/>\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\/edu\/prestashop\/restore-database-backup-prestashop\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Restoring a database backup in PrestaShop 1.5 | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"Need to restore a database backup for your store? Learn how in this PrestaShop 1.5 tutorial.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/\" \/>\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=\"2013-02-15T19:06:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-11T16:11:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/edu_prestashop1.5_restore-db-backup_backup-list.png\" \/>\n<meta name=\"author\" content=\"Scott Mitchell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Scott Mitchell\" \/>\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\/edu\/prestashop\/restore-database-backup-prestashop\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/\"},\"author\":{\"name\":\"Scott Mitchell\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed\"},\"headline\":\"Restoring a database backup in PrestaShop 1.5\",\"datePublished\":\"2013-02-15T19:06:56+00:00\",\"dateModified\":\"2022-03-11T16:11:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/\"},\"wordCount\":288,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/edu_prestashop1.5_restore-db-backup_backup-list.png\",\"articleSection\":[\"Prestashop\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/\",\"name\":\"Restoring a database backup in PrestaShop 1.5 | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/edu_prestashop1.5_restore-db-backup_backup-list.png\",\"datePublished\":\"2013-02-15T19:06:56+00:00\",\"dateModified\":\"2022-03-11T16:11:31+00:00\",\"description\":\"Need to restore a database backup for your store? Learn how in this PrestaShop 1.5 tutorial.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/edu_prestashop1.5_restore-db-backup_backup-list.png\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/edu_prestashop1.5_restore-db-backup_backup-list.png\",\"width\":1021,\"height\":229,\"caption\":\"list of completed backups\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Restoring a database backup in PrestaShop 1.5\"}]},{\"@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\/d850efb28ef3573db7d24b0d8fa9eaed\",\"name\":\"Scott Mitchell\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/scott\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Restoring a database backup in PrestaShop 1.5 | InMotion Hosting","description":"Need to restore a database backup for your store? Learn how in this PrestaShop 1.5 tutorial.","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\/edu\/prestashop\/restore-database-backup-prestashop\/","og_locale":"en_US","og_type":"article","og_title":"Restoring a database backup in PrestaShop 1.5 | InMotion Hosting","og_description":"Need to restore a database backup for your store? Learn how in this PrestaShop 1.5 tutorial.","og_url":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2013-02-15T19:06:56+00:00","article_modified_time":"2022-03-11T16:11:31+00:00","og_image":[{"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/edu_prestashop1.5_restore-db-backup_backup-list.png","type":"","width":"","height":""}],"author":"Scott Mitchell","twitter_card":"summary_large_image","twitter_creator":"@InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"Scott Mitchell","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/"},"author":{"name":"Scott Mitchell","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed"},"headline":"Restoring a database backup in PrestaShop 1.5","datePublished":"2013-02-15T19:06:56+00:00","dateModified":"2022-03-11T16:11:31+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/"},"wordCount":288,"commentCount":0,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/edu_prestashop1.5_restore-db-backup_backup-list.png","articleSection":["Prestashop"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/","url":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/","name":"Restoring a database backup in PrestaShop 1.5 | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/edu_prestashop1.5_restore-db-backup_backup-list.png","datePublished":"2013-02-15T19:06:56+00:00","dateModified":"2022-03-11T16:11:31+00:00","description":"Need to restore a database backup for your store? Learn how in this PrestaShop 1.5 tutorial.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/edu_prestashop1.5_restore-db-backup_backup-list.png","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2013\/02\/edu_prestashop1.5_restore-db-backup_backup-list.png","width":1021,"height":229,"caption":"list of completed backups"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/restore-database-backup-prestashop\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"Restoring a database backup in PrestaShop 1.5"}]},{"@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\/d850efb28ef3573db7d24b0d8fa9eaed","name":"Scott Mitchell","url":"https:\/\/www.inmotionhosting.com\/support\/author\/scott\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":null,"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2462","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\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=2462"}],"version-history":[{"count":3,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2462\/revisions"}],"predecessor-version":[{"id":95042,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/2462\/revisions\/95042"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=2462"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=2462"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=2462"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}