{"id":80098,"date":"2023-08-25T10:45:51","date_gmt":"2023-08-25T09:45:51","guid":{"rendered":"https:\/\/wp.sportdata.org\/knowledge-base\/setup-a-local-database-server\/"},"modified":"2023-08-25T10:45:51","modified_gmt":"2023-08-25T09:45:51","slug":"setup-a-local-database-server","status":"publish","type":"ht_kb","link":"https:\/\/set.sportdata.org\/es\/knowledge-base\/setup-a-local-database-server\/","title":{"rendered":"Setup a local database server"},"content":{"rendered":"\n<p>Setting up a local database server allows you to work offline without an internet connection.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Interactive Demo<\/h2>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-a89b3969 wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button has-custom-width wp-block-button__width-100\"><a class=\"wp-block-button__link has-background has-text-align-center wp-element-button\" href=\"http:\/\/set.sportdata.org\/knowledge-base\/demos\/setup-local-database-server\/Setup_a_local_database_server.html\" style=\"background-color:#ed6969\" target=\"_blank\" rel=\"noreferrer noopener\">Start Interactive Demo<\/a><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Import a database<\/h2>\n\n\n\n<p>To setup a laptop as a local database server, you have to import the database first. Therefor choose the option \u00abImport Database-Backup from SQL-file\u00bb.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_9.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_9.png\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>A pop-up window reminds you, that you have to enter a name for the database to import. You can close it with \u00abOK\u00bb.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_10.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_10.png\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Enter a name for the database in the \u00abDatabase\u00bb text box. This name should not have been used on the same device before, otherwise you will receive an error message.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_11.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_11.png\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Continue by pressing the button \u00abConnect\u00bb.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_12.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_12.png\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Choose the SQL file of the database backup that you would like to import and click on \u00abOpen\u00bb.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_18.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_18.png\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Once the process is finished you get a notification which you can close with \u00abOK\u00bb.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_19.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_19.png\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>In the message console you find all information about the imported database. You can be closed it once the import is finished.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_20.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_20.png\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<div id=\"step21\">&nbsp;<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Connect to the local database<\/h2>\n\n\n\n<p>To connect to the imported local database, select the option \u00abUse local \/ network database\u00bb.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_21.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_21.png\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>In the text box \u00abDatabase\u00bb you have to put in the name of the database that you would like to connect to. As the \u00abServer\u00bb you use \u00ablocalhost\u00bb, since the database is imported on this device. This laptop works now as the local database server.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_22.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_22.png\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>To continue click on \u00abConnect\u00bb.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_23.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_23.png\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>When you connect to a database for the first time, the software will automatically upgrade the database. You can close these windows afterwards.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_24.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_24.png\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>After you enter the SET-Username and password of the database backup, choose the \u00abAdministration Mode\u00bb and continue by pressing the \u00abLog in\u00bb-button.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_25.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_25.png\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Here you find information about the database you are connecting to, like the name and date of the event the database belongs to. Click on \u00abNext\u00bb to continue.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_26.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_26.png\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Next to the event name on top of the Main Tree Menu, you find now the information \u00ab(local)\u00bb, which indicates that you are working on a local database.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_27.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_27.png\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<div id=\"step29\">&nbsp;<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Change the IP-adress of the local database server<\/h2>\n\n\n\n<p>If you want to work with multiple devices on the same database, you should give the local database server a static IP-address. Therefor open the network settings and click on \u00abChange adapter options\u00bb.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_29.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_29.png\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Right-click on the connection of the local network in which you want to use this local database server (preferable Ethernet connection).<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_30.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_30.png\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Open the \u00abProperties\u00bb from the menu.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_31.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_31.png\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Select the \u00abIPv4\u00bb item and click on \u00abProperties\u00bb.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_40.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_40.png\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Instead of obtaining an IP address automatically, choose the option \u00abUse the following IP address\u00bb. Make sure to use the corresponding IP address range of your router which no other device in the network uses at the same time.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_34.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_34.png\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>To check your current IP-address and the Subnet mask, enter the command \u00abipconfig\u00bb in the command prompt. Use the same IP-address range and subnet mask for the static IP-address. Click on \u00abOK\u00bb to save the changes. The IP-address of the local database server is now successfully changed.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_39.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Setup_a_local_database_server_39.png\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Setting up a local database server allows you to work offline without an internet connection. Interactive Demo Import a database To setup a laptop as a local database server, you have to import the database first. Therefor choose the option \u00abImport Database-Backup from SQL-file\u00bb. A pop-up window reminds you, that you have to enter a [&hellip;]<\/p>\n","protected":false},"author":3,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"ht-kb-category":[489,502],"ht-kb-tag":[31],"class_list":["post-80098","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-getting-started-es","ht_kb_category-install-login-es","ht_kb_tag-database"],"acf":[],"_links":{"self":[{"href":"https:\/\/set.sportdata.org\/es\/wp-json\/wp\/v2\/ht-kb\/80098","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/set.sportdata.org\/es\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/set.sportdata.org\/es\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/set.sportdata.org\/es\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/set.sportdata.org\/es\/wp-json\/wp\/v2\/comments?post=80098"}],"version-history":[{"count":0,"href":"https:\/\/set.sportdata.org\/es\/wp-json\/wp\/v2\/ht-kb\/80098\/revisions"}],"wp:attachment":[{"href":"https:\/\/set.sportdata.org\/es\/wp-json\/wp\/v2\/media?parent=80098"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/set.sportdata.org\/es\/wp-json\/wp\/v2\/ht-kb-category?post=80098"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/set.sportdata.org\/es\/wp-json\/wp\/v2\/ht-kb-tag?post=80098"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}