{"id":1832,"date":"2012-10-04T16:18:53","date_gmt":"2012-10-04T16:18:53","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2012\/10\/04\/db-backup\/"},"modified":"2021-08-16T23:34:21","modified_gmt":"2021-08-17T03:34:21","slug":"db-backup","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/db-backup\/","title":{"rendered":"Creating a Database backup in PrestaShop 1.5"},"content":{"rendered":"

Continuing in our Advanced Parameters<\/a> course, we come to the Database Backup section. This section allows you create database backups and adjust the settings for importing them. Below are the instructions for how to perform these tasks in PrestaShop 1.5<\/p>\n

Configuring the CSV Import in PrestaShop 1.5<\/strong><\/p>\n

    \n
  1. Log into your PrestaShop 1.5 dashboard<\/a>.<\/li>\n
  2. Using the top menu bar, hover over the Advanced Parameters<\/strong> tab and click on the DB Backup<\/strong> option from the menu.<\/li>\n
  3. This brings you to the DB Backup<\/em> page. Be sure to read the disclaimer before selecting the I have read the disclaimer \u2013 Create a new backup<\/strong> button. Click the button when ready to make the backup.
    \"db-backup\"<\/a>\n
    <\/div>\n<\/li>\n
  4. Your backup should now appear in the lower section of the screen.
    \"dbbackup-adv-parameters\"<\/a>\n
    <\/div>\n

    The advanced parameters only consist of two settings. <\/p>\n\n\n\n\n
    Ignore Statistics Tables<\/th>\nEnabling this option will cause the backup to ignore the statistics tables when creating the backup.<\/td>\n<\/tr>\n
    Drop Existing Tables During Import<\/th>\nThis option will cause the import to drop existing tables prior to importing the data from the backup file.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    Continuing in our Advanced Parameters course, we come to the Database Backup section. This section allows you create database backups and adjust the settings for importing them. Below are the instructions for how to perform these tasks in PrestaShop 1.5 Configuring the CSV Import in PrestaShop 1.5 Log into your PrestaShop 1.5 dashboard. Using the 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":[4315,92,4288,4305],"tags":[],"class_list":["post-1832","post","type-post","status-publish","format-standard","hentry","category-backup-and-restore","category-prestashop","category-website","category-databases"],"acf":[],"yoast_head":"\nCreating a Database backup in PrestaShop 1.5 | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"This PrestaShop 1.5 article guides you through making a backup of your database.\" \/>\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\/db-backup\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating a Database backup in PrestaShop 1.5 | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"This PrestaShop 1.5 article guides you through making a backup of your database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/db-backup\/\" \/>\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=\"2012-10-04T16:18:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-17T03:34:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Advanced_Paramaters_DB_Backup_db-backup.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\/db-backup\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/db-backup\/\"},\"author\":{\"name\":\"Scott Mitchell\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed\"},\"headline\":\"Creating a Database backup in PrestaShop 1.5\",\"datePublished\":\"2012-10-04T16:18:53+00:00\",\"dateModified\":\"2021-08-17T03:34:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/db-backup\/\"},\"wordCount\":177,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/db-backup\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Advanced_Paramaters_DB_Backup_db-backup.png\",\"articleSection\":[\"Backups and Restorations\",\"Prestashop\",\"Website\",\"Working with Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/db-backup\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/db-backup\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/db-backup\/\",\"name\":\"Creating 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\/db-backup\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/db-backup\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Advanced_Paramaters_DB_Backup_db-backup.png\",\"datePublished\":\"2012-10-04T16:18:53+00:00\",\"dateModified\":\"2021-08-17T03:34:21+00:00\",\"description\":\"This PrestaShop 1.5 article guides you through making a backup of your database.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/db-backup\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/db-backup\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/db-backup\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Advanced_Paramaters_DB_Backup_db-backup.png\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Advanced_Paramaters_DB_Backup_db-backup.png\",\"width\":409,\"height\":420,\"caption\":\"db-backup\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/db-backup\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating 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 & 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":"Creating a Database backup in PrestaShop 1.5 | InMotion Hosting","description":"This PrestaShop 1.5 article guides you through making a backup of your database.","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\/db-backup\/","og_locale":"en_US","og_type":"article","og_title":"Creating a Database backup in PrestaShop 1.5 | InMotion Hosting","og_description":"This PrestaShop 1.5 article guides you through making a backup of your database.","og_url":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/db-backup\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2012-10-04T16:18:53+00:00","article_modified_time":"2021-08-17T03:34:21+00:00","og_image":[{"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Advanced_Paramaters_DB_Backup_db-backup.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\/db-backup\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/db-backup\/"},"author":{"name":"Scott Mitchell","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/d850efb28ef3573db7d24b0d8fa9eaed"},"headline":"Creating a Database backup in PrestaShop 1.5","datePublished":"2012-10-04T16:18:53+00:00","dateModified":"2021-08-17T03:34:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/db-backup\/"},"wordCount":177,"commentCount":0,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/db-backup\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Advanced_Paramaters_DB_Backup_db-backup.png","articleSection":["Backups and Restorations","Prestashop","Website","Working with Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/db-backup\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/db-backup\/","url":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/db-backup\/","name":"Creating 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\/db-backup\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/db-backup\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Advanced_Paramaters_DB_Backup_db-backup.png","datePublished":"2012-10-04T16:18:53+00:00","dateModified":"2021-08-17T03:34:21+00:00","description":"This PrestaShop 1.5 article guides you through making a backup of your database.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/db-backup\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/db-backup\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/db-backup\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Advanced_Paramaters_DB_Backup_db-backup.png","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2012\/10\/edu_prestashop1.5_Advanced_Paramaters_DB_Backup_db-backup.png","width":409,"height":420,"caption":"db-backup"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/prestashop\/db-backup\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"Creating 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 & 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\/1832","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=1832"}],"version-history":[{"count":2,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/1832\/revisions"}],"predecessor-version":[{"id":85551,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/1832\/revisions\/85551"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=1832"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=1832"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=1832"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}