{"id":186520,"date":"2021-04-12T15:16:14","date_gmt":"2021-04-12T13:16:14","guid":{"rendered":"https:\/\/guide.jtl-software.com\/creating-a-database-backup-of-jtl-shop\/"},"modified":"2024-03-21T10:19:06","modified_gmt":"2024-03-21T09:19:06","slug":"creating-a-database-backup-of-jtl-shop","status":"publish","type":"page","link":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/creating-a-database-backup-of-jtl-shop\/","title":{"rendered":"Creating a database backup of JTL-Shop"},"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\">\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-shop\"><\/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-shop\" id=\"creating-a-database-backup-of-jtl-shop\">Creating a database backup of JTL-Shop <span id='anchor-creating-a-database-backup-of-jtl-shop' data-href='#creating-a-database-backup-of-jtl-shop' 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 would like to carry out certain work on your JTL-Shop, for example, installing a new version of JTL-Shop. In order to test these changes safely and not risk any data loss, you would like to back up the JTL-Shop database.\t<\/div>\n<\/div>\n<h2 class=\"d-flex align-items-center hl-wawi\" id=\"general-information-on-the-subject-of-jtl-shop-backups\">General information on the subject of JTL-Shop backups <span id='anchor-general-information-on-the-subject-of-jtl-shop-backups' data-href='#general-information-on-the-subject-of-jtl-shop-backups' class='far fa-link' data-anchor><\/span><\/h2>\t<p>The data that makes up your JTL-Shop comes from three sources:<\/p>\n<ul class=\"list-reset ml-3 list-icons list-custom-square list-shop\">\n\t<li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tItem, stock, price, category, and manufacturer information is transferred from JTL-Wawi. It is located in the JTL-Wawi database.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tCustomer, order, newsletter, and much other data is stored in the JTL-Shop database.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tShop files, which range from core files (not data), installation configuration and your template to media files and item images, are stored in the web space.\t<\/li><\/ul>\t<p>To be fully protected against data loss, you therefore need to create backups for all three locations or have them created. Depending on the data, we recommend the following intervals:<\/p>\n<ul class=\"list-reset ml-3 list-icons list-custom-square list-shop\">\n\t<li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>JTL-Wawi database:<\/b> daily. Learn how to create a backup of the JTL-Wawi database: <span style=\"color: #f68b25;\"> <a class=\"JTL-Wawi-color\" style=\"color: #f68b25;\" title=\"Database management\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/performing-a-database-backup\/\">Creating a database backup<\/a><\/span>.\r\n\r\n\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Database of JTL-Shop:<\/b> regular daily backups. Usually, your hosting provider takes care of this; contact them for details. You should also make separate backups before any major changes such as updates to a new version.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Shop files:<\/b> after every change. For example, a backup is needed when you adjust the template or change settings. To do this, either copy your entire template and all files that change, or in the case of larger changes (e.g. an update; follow the update instructions) copy all files from the root directory of your JTL-Shop from the server to another location.\t<\/li><\/ul><h3 class=\"d-flex align-items-center hl-wawi\" id=\"difference-between-regular-and-special-backup\">Difference between regular and special backup <span id='anchor-difference-between-regular-and-special-backup' data-href='#difference-between-regular-and-special-backup' class='far fa-link' data-anchor><\/span><\/h3>\t<p>There are two different kinds of backup:<\/p>\n\t<p><b>Regular backup:<\/b> This is usually created automatically by the hosting provider at regular intervals (e.g. once every night) and kept for a certain period of time. In the event of unexpected data loss, it can be used for recovery.<\/p>\n\t<p><b>Special backup:<\/b> In some situations, it is advisable to create a separate backup, for example because you will be making critical changes. The simplest example is a version update.<\/p>\n\t<p>With these special, separate backups, there are a few things you need to keep in mind to avoid errors, data loss or even \u201cdatabase asynchrony\u201d afterwards.<\/p>\n<div id=\"parent_69e08d357b51c\" role=\"tablist\" aria-multiselectable=\"true\" class=\"accordion mb-5 parent_69e08d357b51c\">\n\t<div class=\"accordion-group\">\n\t<div class=\"accordion-header no-gradient collapsed\" role=\"tab\" id=\"group_69e08d357b67b\" data-toggle=\"collapse\" data-target=\"#group_69e08d357b67b_collapse\" aria-expanded=\"true\" aria-controls=\"group_69e08d357b67b_collapse\">\n\t\t<div class=\"accordion-title\">\n\t\t\tWhat does \u201cdatabase asynchrony\u201d mean for you?\t\t\t<span class=\"fas fa-caret-up indicator\"><\/span>\n\t\t<\/div>\n\t<\/div>\n\t<div id=\"group_69e08d357b67b_collapse\" class=\"accordion-collapse collapse \" role=\"tabpanel\" aria-labelledby=\"group_69e08d357b67b\" data-parent=\".parent_69e08d357b51c\">\n\t\t<div class=\"accordion-body clearfix\">\n\t\t\t\t<p>JTL-Shop works together with JTL-Wawi. Both use independent databases (JTL-Wawi: MSSQL database, JTL-Shop: MySQL database), which are synchronised via the online shop synchronisation. Asynchrony is when the data in JTL-Wawi and JTL-Shop are not the same despite successful synchronisation.<\/p>\n<p class=\"d-flex align-items-center hl-wawi h6\">Examples:<\/p><ul class=\"list-reset ml-3 list-icons list-custom-square list-shop\">\n\t<li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tAn item price was changed in JTL-Wawi and despite the synchronisation, this price is not in JTL-Shop.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tAn order was placed in JTL-Shop and although it is marked as synchronised in the order history in the back end of JTL-Shop, it cannot be found in JTL-Wawi.\t<\/li><\/ul>\t<p>The origin of these errors can also be cache or general alignment issues. First you should check the browser cache, template cache and object cache in the back end of JTL-Shop under <span class=\"highlight\">System &gt; Cache<\/span>.<\/p>\n\t<p>However, such an asynchrony can also be created when an old database backup is imported.<\/p>\n<p class=\"d-flex align-items-center hl-wawi h6\">Example:<\/p><ul class=\"list-reset ml-3 list-icons list-custom-square list-shop\">\n\t<li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tYou change item prices in JTL-Wawi and then carry out a synchronisation with JTL-Shop. The prices are displayed correctly there.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tYou import a backup into JTL-Shop that was created before the last adjustment\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tFrom now on, the two databases are asynchronous with regard to the item prices, because the old prices are still in JTL-Shop while the new prices are stored in JTL-Wawi. With a normal synchronisation this cannot be solved since JTL-Wawi does not know that JTL-Shop no longer has the newer data. The affected data must therefore first be transferred again in JTL-Wawi via a complete synchronisation.\t<\/li><\/ul>\t\t<\/div>\n\t<\/div>\n<\/div><\/div>\n<h2 class=\"d-flex align-items-center hl-wawi\" id=\"step-1-preparations-for-the-backup\">Step 1: Preparations for the backup <span id='anchor-step-1-preparations-for-the-backup' data-href='#step-1-preparations-for-the-backup' class='far fa-link' data-anchor><\/span><\/h2>\t<p>Before you create a backup, you should make some preparations that will allow you to carry out the planned maintenance work or desired changes afterwards.<\/p>\n<ol start=\"1\" class=\"list-reset step mb-5 list-shop normal-step\">\n\t<li class=\"media-single-line\">\n\tPlace JTL-Shop in maintenance mode in the back end under <span class=\"highlight\">Settings &gt; Global<\/span>.<\/li><li >\n\tFrom now on, do not carry out any more synchronisations with JTL-Wawi. If you use the background service JTL-Worker, stop it and deactivate it in JTL-Wawi under <span class=\"highlight\">Admin &gt; JTL-Worker<\/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-compass fa-2x columnsize-fa-2x text-shop\"><\/span>\n\t\t\t<span class=\"media-content border-shop\">\n\t\n\t\t\tAlternatively, you can also deactivate only the online shop synchronisation in JTL-Worker by activating the check box <span class=\"highlight\">Keinen Onlineshop-Abgleich f\u00fcr diesen Mandanten durchf\u00fchren<\/span> (Do not perform online shop synchronisation for this tenant) and then restarting JTL-Worker.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<ol start=\"3\" class=\"list-reset step mb-5 list-shop normal-step\">\n\t<li class=\"media-single-line\">\n\tFrom now on, do not change any settings in the back end.<\/li><\/ol><h2 class=\"d-flex align-items-center hl-wawi\" id=\"step-2-creating-database-backups-of-jtl-shop\">Step 2: Creating database backups of JTL-Shop <span id='anchor-step-2-creating-database-backups-of-jtl-shop' data-href='#step-2-creating-database-backups-of-jtl-shop' class='far fa-link' data-anchor><\/span><\/h2>\t<p>Database backups of JTL-Shop are also called SQL dumps. These contain the entire database of JTL-Shop, including all data stored there such as orders, customers, and settings for newsletter recipients. They do not contain any installation or configuration-specific data (e.g. database access credentials for connecting shop files to the database; Blowfish key for encrypting and decrypting customer data), templates, item images, etc. To save these, you must save the shop files from the root directory on the server.<\/p>\n\t<p>In principle, you should always have database backups carried out by an expert. Ideally, this is done by your hosting\/Internet provider, a server administrator specifically responsible for this, or a JTL service partner. They usually also know best how to automate the backup process and recognise at an early stage whether there could be problems.<\/p>\n\t<p>Should you nevertheless create a backup yourself, the available options depend on the individual hosting provider. We therefore recommend that you check with your hosting provider first.<br \/>\nWe will briefly explain the possible use of PHPMyAdmin, which is available almost everywhere, and then the use of Plesk, which is possible, for example, with a shop hosted by JTL.<\/p>\n<h3 class=\"d-flex align-items-center hl-wawi\" id=\"possibility-1-backup-using-phpmyadmin\">Possibility 1: Backup using PHPMyAdmin <span id='anchor-possibility-1-backup-using-phpmyadmin' data-href='#possibility-1-backup-using-phpmyadmin' class='far fa-link' data-anchor><\/span><\/h3><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-exclamation-circle fa-2x columnsize-fa-2x text-shop\"><\/span>\n\t\t\t<span class=\"media-content border-shop\">\n\t\n\t\t\t<b>Important information:<\/b> Due to server configuration and script runtimes, large databases can lead to problems when PHPMyAdmin is used, and the backup may not be created correctly. In this case, please contact your hosting provider regarding the backup! With a database size of more than 200MB, unusable results are to be expected with this method.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<ol start=\"1\" class=\"list-reset step mb-5 list-shop normal-step\">\n\t<li >\n\tOpen PHPMyAdmin and in the <span class=\"highlight\">Databases<\/span> section, select the database for which you want to create a backup.<\/li><li class=\"media-single-line\">\n\tSwitch to the <span class=\"highlight\">Export<\/span> tab.<\/li><li class=\"media-single-line\">\n\tSet the following settings in PHPMyAdmin for an export of the JTL-Shop database:<\/li><\/ol><ul class=\"list-reset ml-3 list-icons list-custom-square list-shop\">\n\t<li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tExport method: Custom\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tTables: Check all, even structure and data!\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tCompression: Select \u201czip\u201d or \u201cgzip\u201d.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tCheck the option \u201cAdd DROP TABLE \/ VIEW \/ PROCEDURE \/ FUNCTION \/ EVENT \/ TRIGGER statement\u201d.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tAdd some zeros in the setting \u201cMaximum length of created query\u201d, especially for large databases.\t<\/li><\/ul>\t<p>Your settings will then look like this:<\/p>\n\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\/maintenance-db-backup-phpmyadmin-jtl-shop-5-1.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/maintenance-db-backup-phpmyadmin-jtl-shop-5-1.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/maintenance-db-backup-phpmyadmin-jtl-shop-5-1.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/maintenance-db-backup-phpmyadmin-jtl-shop-5-1-592x1024.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/maintenance-db-backup-phpmyadmin-jtl-shop-5-1-444x768.png 640w\" width=\"1333\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"2304\" alt=\"Backup file for JTL-Shop\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/maintenance-db-backup-phpmyadmin-jtl-shop-5-1.png&quot;,&quot;w&quot;:1333,&quot;h&quot;:2304}\" 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=\"4\" class=\"list-reset step mb-5 list-shop normal-step\">\n\t<li >\n\tClick <span class=\"highlight\">OK<\/span> to create the database backup. You can then save it locally on your hard drive. Continue with step 3.<\/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-exclamation-circle fa-2x columnsize-fa-2x text-shop\"><\/span>\n\t\t\t<span class=\"media-content border-shop\">\n\t\n\t\t\t<b>Important information:<\/b> Always check the saved file afterwards. Do not just assume that it worked. This is also important for regular backups. In an emergency, it does not matter how many backups you create if they are all defective.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<h3 class=\"d-flex align-items-center hl-wawi\" id=\"possibility-2-backup-using-plesk\">Possibility 2: Backup using Plesk <span id='anchor-possibility-2-backup-using-plesk' data-href='#possibility-2-backup-using-plesk' class='far fa-link' data-anchor><\/span><\/h3>\t<p>You can find more information about Plesk and how to access it as a JTL-Hosting customer under <span style=\"color: #5cbcf6;\"><a style=\"color: #5cbcf6;\" href=\"https:\/\/guide.jtl-software.com\/jtl-shop\/testshop-jtl-shop-hosting\/e-mail-adressen-und-ftp-zugaenge-fuer-jtl-shop-hosting-verwalten\/\">Managing email addresses and FTP access for JTL-Hosting for JTL-Shop<\/a><\/span>.<\/p>\n<ol start=\"1\" class=\"list-reset step mb-5 list-shop normal-step\">\n\t<li class=\"media-single-line\">\n\tLog in to your Plesk account.<\/li><li class=\"media-single-line\">\n\tClick on <span class=\"highlight\">Databases &gt; Export Dump<\/span>.<\/li><li >\n\tIn the next step, you must specify the destination directory.\nWe recommend the directory <span class=\"highlight\">\/httpdocs\/export\/backup<\/span> (it is protected from direct access via .htaccess. You cannot download the backup with your browser, but you can access it via FTP and the Plesk file browser).\nYou can also choose here whether the file should be downloaded immediately.<\/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\/datenbank-exportieren-jtlshop5.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/datenbank-exportieren-jtlshop5.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/datenbank-exportieren-jtlshop5.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/datenbank-exportieren-jtlshop5.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/datenbank-exportieren-jtlshop5.png 640w\" width=\"686\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"481\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/datenbank-exportieren-jtlshop5.png&quot;,&quot;w&quot;:686,&quot;h&quot;:481}\" 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=\"4\" class=\"list-reset step mb-5 list-shop normal-step\">\n\t<li class=\"media-single-line\">\n\tClick <span class=\"highlight\">OK<\/span> to create the database backup and continue with step 3.<\/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-exclamation-circle fa-2x columnsize-fa-2x text-shop\"><\/span>\n\t\t\t<span class=\"media-content border-shop\">\n\t\n\t\t\t<b>Important information:<\/b> Always check the saved file afterwards. Do not just assume that it worked. This is also important for regular backups. In an emergency, it does not matter how many backups you create if they are all defective.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<h2 class=\"d-flex align-items-center hl-wawi\" id=\"step-3-follow-up\">Step 3: Follow-up <span id='anchor-step-3-follow-up' data-href='#step-3-follow-up' class='far fa-link' data-anchor><\/span><\/h2><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-exclamation-circle fa-2x columnsize-fa-2x text-shop\"><\/span>\n\t\t\t<span class=\"media-content border-shop\">\n\t\n\t\t\t<b>Important information:<\/b> This is the procedure without errors. If data loss\/asynchrony occurs, further steps are necessary.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<ol start=\"1\" class=\"list-reset step mb-5 list-shop normal-step\">\n\t<li >\n\tCarry out your necessary work (e.g. the update; go to help pages on<span style=\"color: #5cbcf6;\"> <a class=\"JTL-Shop-color\" style=\"color: #5cbcf6;\" title=\"Updating JTL-Shop\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/jtl-shop-fee-based-editions\/updating-jtl-shop\/\">Carrying out the update<\/a><\/span>).<\/li><li >\n\tCheck whether your JTL-Shop has serious errors. The various integrated test methods in <span class=\"highlight\">Troubleshooting &gt; Diagnostics &gt; File structure<\/span>, the <span class=\"highlight\">directory rights<\/span>, and the <span class=\"highlight\">database structure<\/span> will help you here.&nbsp;In addition, we recommend that you take a close look at your online shop after the changes and check all important functions.<\/li><\/ol><ul class=\"mb-5 ml-6 list-reset ml-3 list-icons list-custom-square list-shop\">\n\t<li >\n\t<a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/checking-the-file-structure\/\" title=\"Go to \u201cChecking the shop files\u201d\">\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tGo to \u201cChecking the file structure\u201d\t<\/a><\/li><li >\n\t<a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/checking-directory-permissions\/\" title=\"Go to \u201cChecking directories\u201d\">\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tGo to \u201cChecking directory permissions\u201d\t<\/a><\/li><li >\n\t<a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/checking-the-database-structure\/\" title=\"Go to \u201cChecking the database\u201d\">\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tGo to \u201cChecking the database structure\u201d\t<\/a><\/li><\/ul><ol start=\"3\" class=\"list-reset step mb-5 list-shop normal-step\">\n\t<li >\n\tIf no errors occur, you may now carry out the online shop synchronisation again, reactivate the background service JTL-Worker if necessary and continue with your normal work. If errors occur, read the instructions<span style=\"color: #5cbcf6;\"> <a class=\"JTL-Shop-color\" style=\"color: #5cbcf6;\" title=\"Restoring JTL-Shop database backups\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/restoring-jtl-shop-database-backups\/\">Restoring a database backup<\/a><\/span>.<\/li><li class=\"media-single-line\">\n\tDeactivate the maintenance mode under <span class=\"highlight\">Settings &gt; Global<\/span>.<\/li><\/ol>[\/vc_column][\/vc_row]<\/div>","protected":false},"excerpt":{"rendered":"Contents Contents Creating a database backup of JTL-Shop Your task\/initial situation You would like to carry out certain work on <a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/creating-a-database-backup-of-jtl-shop\/\">[...]<\/a>","protected":false},"author":2,"featured_media":0,"parent":187831,"menu_order":286,"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-186520","page","type-page","status-publish","hentry","search_categorie-jtl-shop"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Creating a database backup of JTL-Shop &#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-shop\/maintenance\/creating-a-database-backup-of-jtl-shop\/\" \/>\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 of JTL-Shop &#8211; JTL-Guide\" \/>\n<meta property=\"og:url\" content=\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/creating-a-database-backup-of-jtl-shop\/\" \/>\n<meta property=\"og:site_name\" content=\"JTL-Guide\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T09:19:06+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=\"13 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-shop\/maintenance\/creating-a-database-backup-of-jtl-shop\/\",\"url\":\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/creating-a-database-backup-of-jtl-shop\/\",\"name\":\"Creating a database backup of JTL-Shop &#8211; JTL-Guide\",\"isPartOf\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/#website\"},\"datePublished\":\"2021-04-12T13:16:14+00:00\",\"dateModified\":\"2024-03-21T09:19:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/creating-a-database-backup-of-jtl-shop\/#breadcrumb\"},\"inLanguage\":\"en-en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/creating-a-database-backup-of-jtl-shop\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/creating-a-database-backup-of-jtl-shop\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"JTL-Shop\",\"item\":\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Maintenance\",\"item\":\"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/wartung\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Creating a database backup of JTL-Shop\"}]},{\"@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 a database backup of JTL-Shop &#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-shop\/maintenance\/creating-a-database-backup-of-jtl-shop\/","og_locale":"en_US","og_type":"article","og_title":"Creating a database backup of JTL-Shop &#8211; JTL-Guide","og_url":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/creating-a-database-backup-of-jtl-shop\/","og_site_name":"JTL-Guide","article_modified_time":"2024-03-21T09:19:06+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"13 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/creating-a-database-backup-of-jtl-shop\/","url":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/creating-a-database-backup-of-jtl-shop\/","name":"Creating a database backup of JTL-Shop &#8211; JTL-Guide","isPartOf":{"@id":"https:\/\/guide.jtl-software.com\/en\/#website"},"datePublished":"2021-04-12T13:16:14+00:00","dateModified":"2024-03-21T09:19:06+00:00","breadcrumb":{"@id":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/creating-a-database-backup-of-jtl-shop\/#breadcrumb"},"inLanguage":"en-en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/creating-a-database-backup-of-jtl-shop\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/maintenance\/creating-a-database-backup-of-jtl-shop\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"JTL-Shop","item":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/"},{"@type":"ListItem","position":2,"name":"Maintenance","item":"https:\/\/guide.jtl-software.com\/en\/jtl-shop\/wartung\/"},{"@type":"ListItem","position":3,"name":"Creating a database backup of JTL-Shop"}]},{"@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\/186520","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=186520"}],"version-history":[{"count":5,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/186520\/revisions"}],"predecessor-version":[{"id":250135,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/186520\/revisions\/250135"}],"up":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/187831"}],"wp:attachment":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/media?parent=186520"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/tags?post=186520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}