niota

fascinating. logical.

User Tools

Site Tools


niota-docs:niota_install_meta

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
niota-docs:niota_install_meta [2025/05/09 11:42]
admin
niota-docs:niota_install_meta [2025/07/17 14:11] (current)
Line 1: Line 1:
-===== introduction ​===== +===== Introduction ​===== 
-To run niota you need a MySQL DBMS to which you add the niota metadata database (N-MDDB). It depends on the requirements of your IT department which way you have to choose to set up N-MDDB. The possible ​option ​are.+To run niotayou need a [[niota_glossary|MySQL]] [[niota_glossary|DBMS]] to which you add the metadata database ([[niota_glossary|N-MDDB]]). It depends on the requirements of your IT department which way you have to choose to set up N-MDDB. The possible ​options ​are.
  
-  * A install a dedicated niota MySQL Server ​with a pre-installed N-MDDB +  * "A" ​install a dedicated niota MySQL server ​with a pre-installed N-MDDB 
-  * B install a dedicated MySQL Server ​and add the N-MDDB +  * "B" ​install a dedicated MySQL server ​and add the N-MDDB 
-  * C add a pre-configured N-MDDB to an existing MySQL Server +  * "C" ​add a pre-configured N-MDDB to an existing MySQL server 
-  * D create new N-MDDB from MySQL scripts (the hard way)+  * "D" ​create new N-MDDB from MySQL scripts (the hard way) 
 + 
 +Please check [[niota_requirements|system requirements]] for valid combinations of niota application and MySQL server.
  
 ---- ----
Line 11: Line 13:
  
 ===== ''​A''​ install MySQL DBMS with predefined N-MDDB ===== ===== ''​A''​ install MySQL DBMS with predefined N-MDDB =====
-Download the MySQL Server from the [[https://​support.etixpert.com/​tableeditor/​downloads|niota download page]]. The download contains a portable MySQL server with a pre-installed empty N-MDDB. You can use this to set up niota very quickly.+Download the MySQL Server from the [[niota-docs:niota_links|niota download page]]. The download contains a portable MySQL server with a pre-installed empty N-MDDB. You can use this to set up niota very quickly.
 ** Please check the version of the meta database included in this download ** It has to fit the required version of you niota web application. ** Please check the version of the meta database included in this download ** It has to fit the required version of you niota web application.
 Continue with [[niota_install_meta_Windows| Windows - set up MySQL]].\\ Continue with [[niota_install_meta_Windows| Windows - set up MySQL]].\\
Line 25: Line 27:
  
 ===== ''​C''​ add/restore N-MDDB to a MySQL DBMS ===== ===== ''​C''​ add/restore N-MDDB to a MySQL DBMS =====
-If as MySQL Server ​is already up and running you can add a niota metadata database to this server.  +If as MySQL server ​is already up and running you can add a metadata database to this server.  
-Download the Accessory-tools or a provided empty metadata database backup from the [[https://​support.etixpert.com/​tableeditor/​downloads|niota download page]]. +Download the accessory ​tools or a provided empty metadata database backup from the [[niota_links|niota download page]]. 
-Follow the steps listed [[niota_accessory_do_manage_metadb|here]] to add a niota metadata database to you MySQL DBMS.+Follow the steps listed [[niota_accessory_do_manage_metadb|here]] to add a metadata database to you MySQL DBMS.
  
 ===== ''​D''​ set up N-MDDB on a MySQL DBMS ===== ===== ''​D''​ set up N-MDDB on a MySQL DBMS =====
-Download the accessory tools for niota and run all the scripts to set up database step by step. In this accessory folder you can find a **''/​bin''​** folder where all the executables are stored. This is just in case you are not allowed to run a standalone MySQL server for niota or you want to set up database on our own. +Download the accessory tools for niota and run all the scripts to set up database step by step. In this accessory folder you can find a **''/​bin''​** folder where all the executables are stored. This is just in case you are not allowed to run a standalone MySQL server for niota or you want to set up database on our own. Read carefully the docu of the [niota_install_meta_manually|manual set up procedure]] and run it step by step.
  
-=== use embedded MySQL server and install niota metadata database (N-MDDB) as a service ​===+==== Windows ​setup MySQL ====
  
-If MySQL server ​is already running and listening ​on the same port as you want to run niota then you have to change your niota port or stop the other MySQL server+In case of upgrade to a new MySQL server ​version you can use only one MySQL server at the same time on the same port. In case you want the check how niota works with new MySQL server and then again switch back to old MySQL server ​you have to shut down always ​the other. ​ 
 +**There must not be two server listening on the same port**
  
-Execute listed tasks step by step in the given order+If you want to run both server at the same time you can configure niota **''​..\connections.php''​** to switch from one server to the other. ​
  
-  * unzip downloaded NMDDB zip-file 
-  * move extracted folder to target location 
-  * rename the folder to your needs 
    
 **Recommendation:​** **Recommendation:​**
----- +Remove the detailed version info from you target folder
-Remove the detailed version info. +
  
-e.g. rename “niota-meta-80_v2.1.21308” to “niota-meta_v2” +  ​e.g. rename “niota-meta-80_v2.1.21308” to “niota-meta_v2”
----- +
- +
-==== Windows - setup MySQL ====+
  
    
   * navigate to the mysql-<​version>​ - folder and check the configured port in configuration file my.ini   * navigate to the mysql-<​version>​ - folder and check the configured port in configuration file my.ini
  
-Default port 3306 is configured. If you have to change this, then set your desired port number here. If you change the port for N-MDDB you must edit also your connections.php file in N-PAPP and set this port number here as well.+Default port 3306 is configured. If you have to change this, then set your desired port number here. If you change the port for N-MDDB you must edit also your **''​..\connections.php''​** ​file in N-PAPP and set this port number here as well.
  
   * set your ''​data''​ directory.   * set your ''​data''​ directory.
niota-docs/niota_install_meta.1746783733.txt.gz · Last modified: 2025/07/17 14:11 (external edit)