{"id":191596,"date":"2019-07-26T10:51:12","date_gmt":"2019-07-26T08:51:12","guid":{"rendered":"https:\/\/guide.jtl-software.com\/jtl-pos\/import-export\/creating-database-backups\/"},"modified":"2023-08-04T15:44:26","modified_gmt":"2023-08-04T13:44:26","slug":"creating-database-backups","status":"publish","type":"page","link":"https:\/\/guide.jtl-software.com\/en\/jtl-pos\/import-export\/creating-database-backups\/","title":{"rendered":"Creating database backups"},"content":{"rendered":"<div class=\"wpb-content-wrapper\">[vc_row][vc_column width=&#8221;1\/3&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;order-md&#8220;: &#8220;1&#8220;, &#8220;col-lg&#8220;: &#8220;4&#8220;, &#8220;order-lg&#8220;: &#8220;12&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]<div id=\"toc\" class=\"d-print-none\">\n\t<div class=\"card border-0 bg-rysywhite mt-0 mt-lg-5 mb-5 w-100\" data-toc-element>\n\t\t<div class=\"d-none d-lg-flex flex-column\">\n\t\t\t<span class=\"fa-layers mx-auto mt--4 fa-fw fa-3x text-shaftblue\">\n\t\t\t\t<span class=\"fas fa-circle\"><\/span>\n\t\t\t\t<span class=\"fas fa-inverse fa-list-ul\" data-fa-transform=\"shrink-8\"><\/span>\n\t\t\t<\/span>\n\t\t\t<span class=\"font-weight-bold text-shaftblue text-center h5 mt-3 mb-0\">Contents<\/span>\n\t\t<\/div>\n\t\t<div class=\"d-block d-lg-none\">\n\t\t\t<a class=\"text-decoration-none card-header-link collapsed\" data-toggle=\"collapse\" href=\"#collapse-toc\" aria-expanded=\"false\" aria-controls=\"collapse-toc\">\n\t\t\t\t<div class=\"card-header d-flex bg-white align-items-center\" role=\"tab\" id=\"heading-toc\">\n\t\t\t\t\t<span class=\"h4 mb-0 d-flex align-items-center\">\n\t\t\t\t\t\t<span class=\"fa-layers fa-fw fa-2x mr-2 text-shaftblue\">\n\t\t\t\t\t\t\t<span class=\"fas fa-circle\"><\/span>\n\t\t\t\t\t\t\t<span class=\"fas fa-inverse fa-list-ul\" data-fa-transform=\"shrink-8\"><\/span>\n\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t<span>Contents<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<span class=\"flex-shrink-0 ml-auto fas fa-caret-down text-gray\"><\/span>\n\t\t\t\t<\/div>\n\t\t\t<\/a>\n\t\t<\/div>\n\t\t<div id=\"collapse-toc\" class=\"collapse show\" data-parent=\"#toc\" role=\"tabpanel\" aria-labelledby=\"heading-toc\">\n\t\t\t<div class=\"card-body p-4 table-of-content\">\n\t\t\t\t<ul data-toc-headings=\"h2,h3\" data-toc class=\"list-pos\"><\/ul>\n\t\t\t<\/div>\n\t    <\/div>\n\t<\/div>\n<\/div>[\/vc_column][vc_column responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;8&#8220;, &#8220;order-md&#8220;: &#8220;12&#8220;, &#8220;order-lg&#8220;: &#8220;1&#8220;}&#8221; width=&#8221;2\/3&#8243; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;]<h1 class=\"d-flex align-items-center hl-pos\" id=\"creating-database-backups\">Creating database backups <span id='anchor-creating-database-backups' data-href='#creating-database-backups' class='far fa-link' data-anchor><\/span><\/h1><div class=\"custom-box\">\n\t<div class=\"d-flex align-items-center mb-4\">\n\t\t\t\t\t\t\t<span class=\"mr-3 fa-stack flex-shrink-0 fa-1x\">\n\t\t\t<span class=\"fas fa-circle fa-stack-2x text-shaftblue\"><\/span>\n\t\t\t\t\t<span class=\"flex-shrink-0 fas fa-clipboard-list text-white fa-stack-1x\"><\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\n\t\t\n\t\t<h3 class=\"mb-0 \" id=\"your-task-initial-situation\">Your task\/initial situation <span id='anchor-your-task-initial-situation' data-href='#your-task-initial-situation' class='far fa-link' data-anchor><\/span><\/h3>\t<\/div>\n\t<div class=\"box-content\">\n\t\tYou created a complete database in JTL-POS and want to save it. You can either archive the backup or use it to transfer the complete database to a different device.\t<\/div>\n<\/div>\n<h2 class=\"d-flex align-items-center hl-wawi\" id=\"backup-routine\">Backup routine <span id='anchor-backup-routine' data-href='#backup-routine' class='far fa-link' data-anchor><\/span><\/h2>\t<p>If you use JTL-POS productively, you should back up the database at regular intervals. We recommend performing a backup at least once a day. Do not save data backups to the internal storage of your device only. Also save it on a different device, e.g. by transferring it to your computer via email. This is the only way to make sure that your data is safe in case of a device failure.<\/p>\n<h2 class=\"d-flex align-items-center hl-wawi\" id=\"performing-the-backup\">Performing the backup <span id='anchor-performing-the-backup' data-href='#performing-the-backup' class='far fa-link' data-anchor><\/span><\/h2><ol start=\"1\" class=\"list-reset step mb-5 list-pos normal-step\">\n\t<li >\n\tIn JTL-POS, go to <span class=\"highlight\">System<\/span> &gt; <span class=\"highlight\">Data backup<\/span> and open the <span class=\"highlight\">Database<\/span> dialogue box. You are now in the tab <span class=\"highlight\">Back up<\/span>.<\/li><\/ol>\t\t\t\t\t\t<div data-gallery>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/uploads\/create-database-backup-3.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/create-database-backup-3-1024x766.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/create-database-backup-3.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/create-database-backup-3-1024x766.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/create-database-backup-3-768x575.png 640w\" width=\"1024\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"766\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/create-database-backup-3.png&quot;,&quot;w&quot;:1200,&quot;h&quot;:898}\" class=\"border-defaultgray border-w-1 border img-fluid mb-5\">\n\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<ol start=\"2\" class=\"list-reset step mb-5 list-pos normal-step\">\n\t<li class=\"media-single-line\">\n\tSelect a storage location for your backup file.<\/li><\/ol>\t<p><strong>Download folder:<\/strong> Saves the data backup to the download folder in the internal storage of your device.<\/p>\n<hr  \/>\n\t<p><strong>SD card\/microSD card:<\/strong> Saves the database to the inserted SD card.<\/p>\n<hr  \/>\n\t<p><strong>Send via email:<\/strong> Sends the backup file as an attachment to the saved email address. For this you must have set up an <span style=\"color: #336699;\"><a style=\"color: #336699;\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-pos\/setup\/dialogue-box-manage-email-server\/\">email account<\/a><\/span> and a <span style=\"color: #336699;\"><a style=\"color: #336699;\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-pos\/setup\/dialogue-box-manage-recipients\/\">recipient address<\/a><\/span>.<\/p>\n<ol start=\"3\" class=\"list-reset step mb-5 list-pos normal-step\">\n\t<li >\n\tDecide whether to also include the images saved in the database in the backup. Select the option <span class=\"highlight\">Include images<\/span>.<\/li><\/ol><div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-info-circle fa-2x columnsize-fa-2x text-pos\"><\/span>\n\t\t\t<span class=\"media-content border-pos\">\n\t\n\t\t\t<span style=\"color: #336699;\"><strong>Please note:<\/strong><\/span> Databases that contain images may be considerably larger than databases without images. If you perform the backup as part of a daily routine, you might want to forgo backing up the images. However, if you want to use the backup to upload it to another device, you should always enable this option.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<ol start=\"4\" class=\"list-reset step mb-5 list-pos normal-step\">\n\t<li >\n\tDecide whether you want to archive the posting data stored in the database. If you do not want this, select the option <span class=\"highlight\">Exclude posting data<\/span>.<\/li><li >\n\tTap <span class=\"highlight\">Create database backup<\/span>. The backup file is now saved to the selected location. JTL-POS restarts automatically.<\/li><\/ol><div class=\"media-object media-object-border d-flex align-items-top\">\n\t\n\t\t\n\t\t<span class=\"mt-1 mr-3 flex-shrink-0 far fa-info-circle fa-2x columnsize-fa-2x text-pos\"><\/span>\n\t\t\t<span class=\"media-content border-pos\">\n\t\n\t\t\t<span style=\"color: #336699;\"><strong>Please note:<\/strong><\/span> Saved databases can then simply be moved to a different storage location, for example to a Google Drive folder.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<div class=\"mt-5 d-print-none card\">\n\t\t\t<span class=\"fa-layers mx-auto mt--4 fa-fw fa-3x text-pos\">\n\t\t\t<span class=\"fas fa-circle\"><\/span>\n\t\t\t<span data-fa-transform=\"shrink-8\" class=\"fas fa-link fa-inverse\"><\/span>\n\t\t<\/span>\n\t\t\t<div class=\"card-body p-4\">\n\t\t<p class=\"d-flex align-items-center hl-wawi h4\">Related topics<\/p>\n<ul class=\"list-reset list-icons list-custom-square list-pos\">\n\t\t\t\t\t\t<li>\n\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-pos\/import-export\/importing-data-via-csv\/\" title=\"Importing data via CSV\">\n\t\t\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t\t\t\tImporting data via CSV\t\t\t\t<\/a>\n\t\t\t<\/li>\n\t\t\t\t\t<li>\n\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-pos\/import-export\/exporting-data-via-csv\/\" title=\"Exporting data via CSV\">\n\t\t\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t\t\t\tExporting data via CSV\t\t\t\t<\/a>\n\t\t\t<\/li>\n\t\t\t\t\t<li>\n\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-pos\/import-export\/restoring-database-backups\/\" title=\"Restoring database backups\">\n\t\t\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t\t\t\tRestoring database backups\t\t\t\t<\/a>\n\t\t\t<\/li>\n\t\t\t\t<\/ul>\t<\/div>\n<\/div>[\/vc_column][\/vc_row]<\/div>","protected":false},"excerpt":{"rendered":"[vc_row][vc_column width=&#8221;1\/3&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;order-md&#8220;: &#8220;1&#8220;, &#8220;col-lg&#8220;: &#8220;4&#8220;, &#8220;order-lg&#8220;: &#8220;12&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][\/vc_column][vc_column responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;8&#8220;, &#8220;order-md&#8220;: &#8220;12&#8220;, <a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-pos\/import-export\/restoring-database-backups\/\">[&#8230;]<\/a>","protected":false},"author":2,"featured_media":0,"parent":191128,"menu_order":166,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_relevanssi_hide_post":"","_relevanssi_hide_content":"","_relevanssi_pin_for_all":"","_relevanssi_pin_keywords":"","_relevanssi_unpin_keywords":"","_relevanssi_related_keywords":"","_relevanssi_related_include_ids":"","_relevanssi_related_exclude_ids":"","_relevanssi_related_no_append":"","_relevanssi_related_not_related":"","_relevanssi_related_posts":"","_relevanssi_noindex_reason":"","footnotes":""},"tags":[],"class_list":["post-191596","page","type-page","status-publish","hentry","pages_category-jtl-pos-en","pages_category-pos-import-export-en","pages_category-print-3-vorgaenge-kunden-berichte-import-export-en"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Creating database backups &#8211; JTL-Guide<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-pos\/import-export\/creating-database-backups\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating database backups &#8211; JTL-Guide\" \/>\n<meta property=\"og:description\" content=\"[vc_row][vc_column width=&#8221;1\/3&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;order-md&#8220;: &#8220;1&#8220;, &#8220;col-lg&#8220;: &#8220;4&#8220;, &#8220;order-lg&#8220;: &#8220;12&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][\/vc_column][vc_column responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;8&#8220;, &#8220;order-md&#8220;: &#8220;12&#8220;, [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/guide.jtl-software.com\/en\/jtl-pos\/import-export\/creating-database-backups\/\" \/>\n<meta property=\"og:site_name\" content=\"JTL-Guide\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-04T13:44:26+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-pos\/import-export\/creating-database-backups\/\",\"url\":\"https:\/\/guide.jtl-software.com\/en\/jtl-pos\/import-export\/creating-database-backups\/\",\"name\":\"Creating database backups &#8211; JTL-Guide\",\"isPartOf\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/#website\"},\"datePublished\":\"2019-07-26T08:51:12+00:00\",\"dateModified\":\"2023-08-04T13:44:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-pos\/import-export\/creating-database-backups\/#breadcrumb\"},\"inLanguage\":\"en-en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/guide.jtl-software.com\/en\/jtl-pos\/import-export\/creating-database-backups\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-pos\/import-export\/creating-database-backups\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"JTL-POS\",\"item\":\"https:\/\/guide.jtl-software.com\/en\/jtl-pos\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Import\/Export\",\"item\":\"https:\/\/guide.jtl-software.com\/en\/jtl-pos\/import-export\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Creating database backups\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/#website\",\"url\":\"https:\/\/guide.jtl-software.com\/en\/\",\"name\":\"JTL-Guide\",\"description\":\"Dokumentation f\u00fcr die gesamte Produktfamilie von JTL\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/guide.jtl-software.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-en\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating database backups &#8211; JTL-Guide","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:\/\/guide.jtl-software.com\/en\/jtl-pos\/import-export\/creating-database-backups\/","og_locale":"en_US","og_type":"article","og_title":"Creating database backups &#8211; JTL-Guide","og_description":"[vc_row][vc_column width=&#8221;1\/3&#8243; responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;order-md&#8220;: &#8220;1&#8220;, &#8220;col-lg&#8220;: &#8220;4&#8220;, &#8220;order-lg&#8220;: &#8220;12&#8220;}&#8221; advanced=&#8221;{&#8220;class&#8220;: &#8220;&#8220;, &#8220;hash&#8220;: &#8220;&#8220;}&#8221;][\/vc_column][vc_column responsive=&#8221;{&#8220;col&#8220;: &#8220;12&#8220;, &#8220;col-md&#8220;: &#8220;8&#8220;, &#8220;order-md&#8220;: &#8220;12&#8220;, [...]","og_url":"https:\/\/guide.jtl-software.com\/en\/jtl-pos\/import-export\/creating-database-backups\/","og_site_name":"JTL-Guide","article_modified_time":"2023-08-04T13:44:26+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-pos\/import-export\/creating-database-backups\/","url":"https:\/\/guide.jtl-software.com\/en\/jtl-pos\/import-export\/creating-database-backups\/","name":"Creating database backups &#8211; JTL-Guide","isPartOf":{"@id":"https:\/\/guide.jtl-software.com\/en\/#website"},"datePublished":"2019-07-26T08:51:12+00:00","dateModified":"2023-08-04T13:44:26+00:00","breadcrumb":{"@id":"https:\/\/guide.jtl-software.com\/en\/jtl-pos\/import-export\/creating-database-backups\/#breadcrumb"},"inLanguage":"en-en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/guide.jtl-software.com\/en\/jtl-pos\/import-export\/creating-database-backups\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-pos\/import-export\/creating-database-backups\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"JTL-POS","item":"https:\/\/guide.jtl-software.com\/en\/jtl-pos\/"},{"@type":"ListItem","position":2,"name":"Import\/Export","item":"https:\/\/guide.jtl-software.com\/en\/jtl-pos\/import-export\/"},{"@type":"ListItem","position":3,"name":"Creating database backups"}]},{"@type":"WebSite","@id":"https:\/\/guide.jtl-software.com\/en\/#website","url":"https:\/\/guide.jtl-software.com\/en\/","name":"JTL-Guide","description":"Dokumentation f\u00fcr die gesamte Produktfamilie von JTL","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/guide.jtl-software.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-en"}]}},"_links":{"self":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/191596","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/comments?post=191596"}],"version-history":[{"count":5,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/191596\/revisions"}],"predecessor-version":[{"id":226996,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/191596\/revisions\/226996"}],"up":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/191128"}],"wp:attachment":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/media?parent=191596"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/tags?post=191596"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}