{"id":80100,"date":"2023-08-08T12:42:15","date_gmt":"2023-08-08T11:42:15","guid":{"rendered":"https:\/\/wp.sportdata.org\/knowledge-base\/export-import-database\/"},"modified":"2023-08-08T12:42:15","modified_gmt":"2023-08-08T11:42:15","slug":"export-import-database","status":"publish","type":"ht_kb","link":"https:\/\/set.sportdata.org\/es\/knowledge-base\/export-import-database\/","title":{"rendered":"Export &#038; Import Database"},"content":{"rendered":"\n<p>This article explains how to export a database and how to import it to the SET OVR software. <\/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 is-style-fill\"><a class=\"wp-block-button__link has-background wp-element-button\" href=\"http:\/\/set.sportdata.org\/knowledge-base\/demos\/Export-import-database-demo\/Export_Import_Database_demo.html\" style=\"background-color:#ed6969\" target=\"_blank\" rel=\"noreferrer noopener\">Start Interactive Demo<\/a><\/div>\n<\/div>\n\n\n<div class=\"summary\">\n<div id=\"inhalt\">\n<h2 class=\"contentstep\">Export a database online<\/h2>\n<\/div>\n<\/div>\n<p style=\"-qt-block-indent: 0; text-indent: 0px; margin: 0px;\">Login with your event manager account on <a href=\"http:\/\/sportdata.org\"><span style=\"text-decoration: underline; color: #0000ff;\">sportdata.org<\/span><\/a> and go to the event page of your event. Click in the main menu on <span style=\"font-style: italic;\">\u00abExport event data\u00bb.<\/span><\/p>\n<p><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_4.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_4.png\" \/><\/a><\/p>\n<\/p>\n<p style=\"-qt-block-indent: 0; text-indent: 0px; margin: 0px;\">Click on <span style=\"font-style: italic;\">\u00abExport Event Data as SQL file\u00bb<\/span> to be able to import the database in the SET OVR software.<\/p>\n<p><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_5.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_5.png\" \/><\/a><\/p>\n<div id=\"step7\">\u00a0<\/div>\n<h2>Export a database in SET<\/h2>\n<p style=\"-qt-block-indent: 0; text-indent: 0px; margin: 0px;\">You can either be connected to an online or a local database in the \u00abAdministration Mode\u00bb. Go to <span style=\"font-style: italic;\">\u00abPanels\u00bb<\/span> and open the panel <span style=\"font-style: italic;\">\u00abBackup Database\u00bb<\/span>.<\/p>\n<p><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_7.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_7.png\" \/><\/a><\/p>\n<\/p>\n<p style=\"-qt-block-indent: 0; text-indent: 0px; margin: 0px;\">Click on <span style=\"font-style: italic;\">\u00abBackup online database\u00bb<\/span><\/p>\n<p><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_8.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_8.png\" \/><\/a><\/p>\n<\/p>\n<p style=\"-qt-block-indent: 0; text-indent: 0px; margin: 0px;\">Select a direction where you want to save the database.<\/p>\n<p><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_12.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_12.png\" \/><\/a><\/p>\n<\/p>\n<p style=\"-qt-block-indent: 0; text-indent: 0px; margin: 0px;\">Click on \u00abOpen\u00bb to save the backup in the selected folder.<\/p>\n<p><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_13.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_13.png\" \/><\/a><\/p>\n<\/p>\n<p style=\"-qt-block-indent: 0; text-indent: 0px; margin: 0px;\">Once the backup is finished you receive a pop-up message which you can close with <span style=\"font-style: italic;\">\u00abOK\u00bb.<\/span><\/p>\n<p><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_14.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_14.png\" \/><\/a><\/p>\n<\/p>\n<p style=\"-qt-block-indent: 0; text-indent: 0px; margin: 0px;\">You also have the additional option to store the backup in an online cloud. For this option you need to be connected to the internet.<\/p>\n<p><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_15.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_15.png\" \/><\/a><\/p>\n<\/p>\n<p style=\"-qt-block-indent: 0; text-indent: 0px; margin: 0px;\">In this window you find all information about the exported database including the direction. You can close it once the backup is finished.<\/p>\n<p><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_16.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_16.png\" \/><\/a><\/p>\n<\/p>\n<div id=\"step17\">\u00a0<\/div>\n<h2>Import a database in SET<\/h2>\n<p style=\"-qt-block-indent: 0; text-indent: 0px; margin: 0px;\">Select the Online System of your database.<\/p>\n<p><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_17.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_17.png\" \/><\/a><\/p>\n<\/p>\n<p style=\"-qt-block-indent: 0; text-indent: 0px; margin: 0px;\">Select the option <span style=\"font-style: italic;\">\u00abImport Database-Backup from SQL file\u00bb<\/span>.<\/p>\n<p><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_19.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_19.png\" \/><\/a><\/p>\n<\/p>\n<p style=\"-qt-block-indent: 0; text-indent: 0px; margin: 0px;\">A pop-up message reminds you, that you have to enter a name for the database.<\/p>\n<p><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_20.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_20.png\" \/><\/a><\/p>\n<\/p>\n<p style=\"-qt-block-indent: 0; text-indent: 0px; margin: 0px;\">Enter a name for your database here.<\/p>\n<p><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_21.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_21.png\" \/><\/a><\/p>\n<\/p>\n<p style=\"-qt-block-indent: 0; text-indent: 0px; margin: 0px;\">Click on \u00abConnect\u00bb to proceed.<\/p>\n<p><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_22.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_22.png\" \/><\/a><\/p>\n<\/p>\n<p style=\"-qt-block-indent: 0; text-indent: 0px; margin: 0px;\">A file manager pops up, where you can select the backup of the database you want to import.<\/p>\n<p><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_31.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_31.png\" \/><\/a><\/p>\n<\/p>\n<p style=\"-qt-block-indent: 0; text-indent: 0px; margin: 0px;\">Click on <span style=\"font-style: italic;\">\u00abOpen\u00bb<\/span> to import the selected database.<\/p>\n<p><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_44.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_44.png\" \/><\/a><\/p>\n<\/p>\n<p style=\"-qt-block-indent: 0; text-indent: 0px; margin: 0px;\">A pop-up message informs you that the import of the database is finished.<\/p>\n<p><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_45.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_45.png\" \/><\/a><\/p>\n<\/p>\n<p style=\"-qt-block-indent: 0; text-indent: 0px; margin: 0px;\">You can close the information message and the database is successfully imported.<\/p>\n<p><a href=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_46.png\"><img decoding=\"async\" src=\"http:\/\/set.sportdata.org\/wp-content\/uploads\/2023\/08\/Export__Import_Database_46.png\" \/><\/a><\/p>\n<\/p>","protected":false},"excerpt":{"rendered":"<p>This article explains how to export a database and how to import it to the SET OVR software. Interactive Demo Export a database online Login with your event manager account on sportdata.org and go to the event page of your event. Click in the main menu on \u00abExport event data\u00bb. Click on \u00abExport Event Data [&hellip;]<\/p>\n","protected":false},"author":3,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"ht-kb-category":[502],"ht-kb-tag":[31],"class_list":["post-80100","ht_kb","type-ht_kb","status-publish","format-standard","hentry","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\/80100","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=80100"}],"version-history":[{"count":0,"href":"https:\/\/set.sportdata.org\/es\/wp-json\/wp\/v2\/ht-kb\/80100\/revisions"}],"wp:attachment":[{"href":"https:\/\/set.sportdata.org\/es\/wp-json\/wp\/v2\/media?parent=80100"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/set.sportdata.org\/es\/wp-json\/wp\/v2\/ht-kb-category?post=80100"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/set.sportdata.org\/es\/wp-json\/wp\/v2\/ht-kb-tag?post=80100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}