{"id":191986,"date":"2019-01-14T15:11:48","date_gmt":"2019-01-14T14:11:48","guid":{"rendered":"https:\/\/guide.jtl-software.com\/database\/database-administration\/"},"modified":"2024-03-21T10:34:37","modified_gmt":"2024-03-21T09:34:37","slug":"database-administration","status":"publish","type":"page","link":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/database-administration\/","title":{"rendered":"Database management"},"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=\"sticky-top\">\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-wawi\"><\/ul>\n\t\t\t<\/div>\n\t    <\/div>\n\t<\/div>\n<\/div><div class=\"sticky-top d-none d-xs-none d-sm-none d-md-none d-lg-block d-xl-block card\">\n\t\t\t<div class=\"card-body p-4\">\n\t\t<p class=\"mb-xs--4 d-flex align-items-center hl-wawi h3\">Video<\/p><p class=\"d-flex align-items-center hl-wawi h6\">Repairing your database<\/p><div class=\"mb-3 embed-responsive embed-responsive-16by9\">\n\t\t\t<div class=\"embed-responsive-item\" data-youtubeCover=\"{&quot;player&quot;:{&quot;videoID&quot;:&quot;jiIweIo7LPM&quot;}}\">\n\t\t\t\t\t\t\t<div class=\"cover max poster\">\n\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/youtube-thumbs\/jiIweIo7LPM-maxresdefault.jpg\" width=\"560\" height=\"315\">\n\t\t\t\t\t<span class=\"fab fa-youtube video-icon\"><\/span>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t<\/div>\n\t<p>In this video, we show you all the options for repairing your database.<\/p>\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-wawi\" id=\"database-management\">Database management <span id='anchor-database-management' data-href='#database-management' class='far fa-link' data-anchor><\/span><\/h1>\t<p>The database administration allows you to edit\/repair\/optimise the database of the selected tenant. You can open the database administration in JTL-Wawi via <span class=\"highlight\">Menu: Start &gt; Database<\/span>. There you can select an existing tenant or create a new one as well as the respective easyBusiness database you want to edit.<\/p>\n<h2 class=\"d-flex align-items-center hl-wawi\" id=\"requirements\">Requirements <span id='anchor-requirements' data-href='#requirements' class='far fa-link' data-anchor><\/span><\/h2><ul class=\"mb-5 list-reset ml-3 list-icons list-custom-square list-wawi\">\n\t<li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tYou have already <span style=\"color: #f68b25;\"><a style=\"color: #f68b25;\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/installation\/install-jtl-wawi-on-a-single-computer\/\">installed JTL-Wawi<\/a><\/span>.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\tYou have already created an easyBusiness database.\t<\/li><\/ul><h2 class=\"d-flex align-items-center hl-wawi\" id=\"editing-tenants\">Editing tenants <span id='anchor-editing-tenants' data-href='#editing-tenants' class='far fa-link' data-anchor><\/span><\/h2>\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\/Jtl-wawi-datenbankverwaltung-001-Mandanten-bearbeiten.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-001-Mandanten-bearbeiten.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-001-Mandanten-bearbeiten.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-001-Mandanten-bearbeiten-1024x536.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-001-Mandanten-bearbeiten-768x402.png 640w\" width=\"1426\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"746\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-datenbankverwaltung-001-Mandanten-bearbeiten.png&quot;,&quot;w&quot;:1426,&quot;h&quot;:746}\" class=\"mb-5 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\t<p>In the <span class=\"highlight\">Editing tenants<\/span> dialogue box, you can choose from the following options:<\/p>\n<ul class=\"mb-5 list-reset ml-3 list-icons list-custom-square list-wawi\">\n\t<li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Database export<\/b>: To keep your data safe, you can export your database at any time.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Database import<\/b>: Needless to say, database backups can always be reimported.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Database clean-up<\/b>: If you have already been working with JTL-Wawi for some time, you should clean up the database.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Repair database<\/b>: If there are corrupted files in your database, you can repair them.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Performance optimisation<\/b>: We recommend carrying out a performance optimisation after large data imports with JTL-DataTransfer.\t<\/li><\/ul><h3 class=\"d-flex align-items-center hl-wawi\" id=\"database-export\">Database export <span id='anchor-database-export' data-href='#database-export' class='far fa-link' data-anchor><\/span><\/h3>\t<p>Read here how to create database backups of JTL-Wawi: <span style=\"color: #f68b25;\"><a style=\"color: #f68b25;\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/performing-a-database-backup\/\">Creating database backups<\/a><\/span><\/p>\n<h3 class=\"d-flex align-items-center hl-wawi\" id=\"database-import\">Database import <span id='anchor-database-import' data-href='#database-import' class='far fa-link' data-anchor><\/span><\/h3>\t<p>Read here how to restore a database backup: <span style=\"color: #f68b25;\"><a style=\"color: #f68b25;\" href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/restoring-a-database-backup\/\">Restoring database backups<\/a><\/span><\/p>\n<h3 class=\"d-flex align-items-center hl-wawi\" id=\"cleaning-your-database\">Cleaning your database <span id='anchor-cleaning-your-database' data-href='#cleaning-your-database' class='far fa-link' data-anchor><\/span><\/h3>\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\/Jtl-wawi-datenbankverwaltung-002-Mandanten-bereinigen.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-002-Mandanten-bereinigen-1024x536.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-002-Mandanten-bereinigen.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-002-Mandanten-bereinigen-1024x536.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-002-Mandanten-bereinigen-768x402.png 640w\" width=\"1024\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"536\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-datenbankverwaltung-002-Mandanten-bereinigen.png&quot;,&quot;w&quot;:1426,&quot;h&quot;:746}\" 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<div class=\"mb-5 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-wawi\"><\/span>\n\t\t\t<span class=\"media-content border-wawi\">\n\t\n\t\t\t<span style=\"color: #f68b25;\"><strong>Attention:<\/strong><\/span> You should always perform a database backup before cleaning the database.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n\t<p>With the menu item <span class=\"highlight\">Database clean-up<\/span>, you can select which data you no longer need and would like to remove.<\/p>\n<ul class=\"mb-5 list-reset ml-3 list-icons list-custom-square list-wawi\">\n\t<li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Inactive items:<\/b> All inactive items are removed from the database.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Unused images:<\/b> All unallocated images are deleted.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Inactive categories:<\/b> All categories marked as inactive in the database will be deleted.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Inactive variations:<\/b> All variations marked as inactive in the database will be deleted.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Inactive suppliers:<\/b> All suppliers marked as inactive in the database will be deleted.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Deleted eA templates\/quotations:<\/b> All unneeded JTL-eazyAuction templates are deleted.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<strong>Delete old completed eBay transactions:<\/strong> Here you can specify whether old eBay transactions should be deleted from the database. In the drop-down menu, you can specify the time period for which you want to delete the transactions.\t<\/li><\/ul>\t<p>It is possible that using the <span class=\"highlight\">Database clean-up<\/span>&nbsp;option frees up some database storage space.<\/p>\n<h3 class=\"d-flex align-items-center hl-wawi\" id=\"repairing-your-database\">Repairing your database <span id='anchor-repairing-your-database' data-href='#repairing-your-database' class='far fa-link' data-anchor><\/span><\/h3>\t<p>Via the <span class=\"highlight\">Repair database<\/span> menu item, you can select what data you would like to repair.<\/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\/Jtl-wawi-datenbankverwaltung-003-Mandanten-reparieren.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-003-Mandanten-reparieren-1024x536.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-003-Mandanten-reparieren.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-003-Mandanten-reparieren-1024x536.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-003-Mandanten-reparieren-768x402.png 640w\" width=\"1024\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"536\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-datenbankverwaltung-003-Mandanten-reparieren.png&quot;,&quot;w&quot;:1426,&quot;h&quot;:746}\" 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<ul class=\"mb-5 list-reset ml-3 list-icons list-custom-square list-wawi\">\n\t<li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Repair customer search:<\/b> Select this option if you receive an SQL error message when searching for customers.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Repair items in broken categories:<\/b> If items are displayed incorrectly after an import, an attempt is made to repair them.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Repair image sorting:<\/b> Repairs image sorting.\t<\/li><\/ul><div class=\"mb-5 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-wawi\"><\/span>\n\t\t\t<span class=\"media-content border-wawi\">\n\t\n\t\t\t<span style=\"color: #f68b25;\"><strong>Note:<\/strong><\/span> The database repair only works with an original database as provided by JTL-Software. If you use third-party modules from other providers that have changed or added to the database structure, you will not be able to use this function.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<h3 class=\"d-flex align-items-center hl-wawi\" id=\"performance-optimisation\">Performance optimisation <span id='anchor-performance-optimisation' data-href='#performance-optimisation' class='far fa-link' data-anchor><\/span><\/h3>\t<p>Use the <span class=\"highlight\">Performance optimisation<\/span> menu item to select which data should be optimised.<\/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\/Jtl-wawi-datenbankverwaltung-004-Mandanten-optimieren.png\" itemprop=\"contentUrl\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-004-Mandanten-optimieren-1024x536.png\" srcset=\"https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-004-Mandanten-optimieren.png 1600w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-004-Mandanten-optimieren-1024x536.png 1024w,https:\/\/guide.jtl-software.com\/uploads\/Jtl-wawi-datenbankverwaltung-004-Mandanten-optimieren-768x402.png 640w\" width=\"1024\" sizes=\"auto, (max-width: 20em) 30vw, (max-width: 30em) 60vw, (max-width: 40em) 90vw\" height=\"536\" data-pswp=\"{&quot;src&quot;:&quot;https:\\\/\\\/guide.jtl-software.com\\\/uploads\\\/Jtl-wawi-datenbankverwaltung-004-Mandanten-optimieren.png&quot;,&quot;w&quot;:1426,&quot;h&quot;:746}\" 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<div class=\"mb-5 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-wawi\"><\/span>\n\t\t\t<span class=\"media-content border-wawi\">\n\t\n\t\t\t<span style=\"color: #f68b25;\"><strong>Attention:<\/strong><\/span> Create a database backup before each performance optimisation.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n\t<p>There are several reasons why performance optimisation is important.<\/p>\n<ul class=\"mb-5 list-reset ml-3 list-icons list-custom-square list-wawi\">\n\t<li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Delete eBay <\/b><b>logs:<\/b> If JTL-Wawi is used with JTL-eazyAuction (eBay) for a longer period of time, the database log will grow quite large. Depending on its size, we recommend deleting the database log once a year.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Delete logs of completed pick lists:<\/b> Completed pick lists will usually not be used again. Depending on shipping volume, a performance optimisation might be a good idea.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Reorganise and newly create indices<\/b>: Indices need to be reorganised, especially after large imports with JTL-DataTransfer into JTL-Wawi. If you have been working with JTL-Wawi for a long time, a reorganisation might be beneficial.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Update statistics:<\/b> Over time, the statistics of a database become inaccurate and may slow down your system. This option allows you to update the statistics. This might take a very long time. We therefore recommend starting the statistics update towards the end of the business day or at the weekend.\t<\/li><li >\n\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t<b>Activate Filestream:<\/b> Activate this option only if you are working with MS SQL Server Express and you reach the 10 GB limit. MS SQL Server Express can manage databases with a maximum size of 10 GB. Filestream removes this limit. Deactivating Filestream involves considerable effort.\t<\/li><\/ul><div class=\"mb-5 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-wawi\"><\/span>\n\t\t\t<span class=\"media-content border-wawi\">\n\t\n\t\t\t<span style=\"color: #f68b25;\"><strong>Attention:<\/strong><\/span> Some virus scanners recognise Filestream files as <strong>malware<\/strong>. To avoid <strong>data loss<\/strong> on your SQL server <strong>whitelist<\/strong> Filestream files in the Defender.\t\t\t<\/span>\n\t\n\t<\/div>\n\n\n<div class=\"sticky-top d-block d-xs-block d-sm-block d-md-block d-lg-none d-xl-none card\">\n\t\t\t<div class=\"card-body p-4\">\n\t\t<p class=\"mb-xs--4 d-flex align-items-center hl-wawi h3\">Video<\/p><p class=\"d-flex align-items-center hl-wawi h6\">Repairing your database<\/p><div class=\"mb-3 embed-responsive embed-responsive-16by9\">\n\t\t\t<div class=\"embed-responsive-item\" data-youtubeCover=\"{&quot;player&quot;:{&quot;videoID&quot;:&quot;jiIweIo7LPM&quot;}}\">\n\t\t\t\t\t\t\t<div class=\"cover max poster\">\n\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/guide.jtl-software.com\/uploads\/youtube-thumbs\/jiIweIo7LPM-maxresdefault.jpg\" width=\"560\" height=\"315\">\n\t\t\t\t\t<span class=\"fab fa-youtube video-icon\"><\/span>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t<\/div>\n\t<p>In this video, we show you all the options for repairing your database.<\/p>\n\t<\/div>\n<\/div><div class=\"card\">\n\t\t\t<span class=\"fa-layers mx-auto mt--4 fa-fw fa-3x text-wawi\">\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-wawi\">\n\t\t\t\t\t\t<li>\n\t\t\t\t<a href=\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/restoring-a-database-backup\/\" title=\"Restoring a database backup\">\n\t\t\t\t\t<span class=\"list-icon fas fa-square\"><\/span>\t\t\t\t\tRestoring a database backup\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-wawi\/database\/restoring-a-database-backup\/\">[&#8230;]<\/a>","protected":false},"author":2,"featured_media":0,"parent":191953,"menu_order":580,"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-191986","page","type-page","status-publish","hentry","search_categorie-jtl-wawi","pages_category-datenbank-en"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Database management &#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-wawi\/database\/database-administration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database management &#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-wawi\/database\/database-administration\/\" \/>\n<meta property=\"og:site_name\" content=\"JTL-Guide\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T09:34:37+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=\"11 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-wawi\/database\/database-administration\/\",\"url\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/database-administration\/\",\"name\":\"Database management &#8211; JTL-Guide\",\"isPartOf\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/#website\"},\"datePublished\":\"2019-01-14T14:11:48+00:00\",\"dateModified\":\"2024-03-21T09:34:37+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/database-administration\/#breadcrumb\"},\"inLanguage\":\"en-en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/database-administration\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/database-administration\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"JTL-Wawi\",\"item\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database\",\"item\":\"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/datenbank\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Database management\"}]},{\"@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":"Database management &#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-wawi\/database\/database-administration\/","og_locale":"en_US","og_type":"article","og_title":"Database management &#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-wawi\/database\/database-administration\/","og_site_name":"JTL-Guide","article_modified_time":"2024-03-21T09:34:37+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/database-administration\/","url":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/database-administration\/","name":"Database management &#8211; JTL-Guide","isPartOf":{"@id":"https:\/\/guide.jtl-software.com\/en\/#website"},"datePublished":"2019-01-14T14:11:48+00:00","dateModified":"2024-03-21T09:34:37+00:00","breadcrumb":{"@id":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/database-administration\/#breadcrumb"},"inLanguage":"en-en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/database-administration\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/database\/database-administration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"JTL-Wawi","item":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/"},{"@type":"ListItem","position":2,"name":"Database","item":"https:\/\/guide.jtl-software.com\/en\/jtl-wawi\/datenbank\/"},{"@type":"ListItem","position":3,"name":"Database management"}]},{"@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\/191986","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=191986"}],"version-history":[{"count":5,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/191986\/revisions"}],"predecessor-version":[{"id":250219,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/191986\/revisions\/250219"}],"up":[{"embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/pages\/191953"}],"wp:attachment":[{"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/media?parent=191986"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/guide.jtl-software.com\/en\/wp-json\/wp\/v2\/tags?post=191986"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}