User Tools
niota-docs:niota_install_meta_manually
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
niota-docs:niota_install_meta_manually [2025/04/03 11:34] admin |
niota-docs:niota_install_meta_manually [2025/07/17 14:11] (current) |
||
|---|---|---|---|
| Line 34: | Line 34: | ||
| ** please check/set our configuration settings in niota_setenv.bat **\\ | ** please check/set our configuration settings in niota_setenv.bat **\\ | ||
| - | MySQL\bin folder | + | <code> |
| - | MySQL server | + | :: could be valid settings - check your local environment |
| - | MySQL port number | + | set nMySQLHome=C:\mysql-8.0.26-winx64\bin |
| - | MySQL admin user | + | set nMySQLServer=localhost |
| + | set nMySQLPort=3366 | ||
| + | set nMySQLAdmin=admin_niota | ||
| + | </code> | ||
| ==== create meta database schemas ==== | ==== create meta database schemas ==== | ||
| Line 48: | Line 50: | ||
| * meta database \\ | * meta database \\ | ||
| * deploy database \\ | * deploy database \\ | ||
| - | * warp (core) database \\ | ||
| + | Mind that there are default names set for schemas. If you must change these defaults for any valid reason, you have to edit ''..\metadata_schemas.sql''. We don't recommend at all to change the default names. | ||
| + | |||
| ** You have to connect to an existing schema to create a new schema. ** | ** You have to connect to an existing schema to create a new schema. ** | ||
| - | eg. | + | |
| - | <code> | + | <code bat setup_metadb.cmd> |
| - | ...\bin>do_setup_metadb sys <mypw> schemas | + | ...\bin>do_setup_metadb sys ***** schemas |
| </code> | </code> | ||
| + | |||
| + | To achieve this, user "admin_niota" has ''ALL PRIVILEGES ON `niota%`.*'' and ''SELECT ON `sys`.*'' | ||
| + | |||
| ==== to have a client or not to have a client? ==== | ==== to have a client or not to have a client? ==== | ||
| Line 72: | Line 78: | ||
| ''..\tools\database\object\clients\client_schemas.sql'' and run script below and run the script | ''..\tools\database\object\clients\client_schemas.sql'' and run script below and run the script | ||
| - | <code> | + | |
| - | eg. | + | <code setup_metadb2.cmd> |
| - | ...\bin>do_setup_metadb sys <mypw> clients | + | ...\bin>do_setup_metadb sys ***** clients |
| </code> | </code> | ||
| or | or | ||
| execute DDL directly in your workbench | execute DDL directly in your workbench | ||
| - | <code> | + | <code sql create_db.sql> |
| CREATE DATABASE if not exists niota_meta_<myID> CHARACTER SET UTF8MB4 COLLATE UTF8MB4_general_ci; | CREATE DATABASE if not exists niota_meta_<myID> CHARACTER SET UTF8MB4 COLLATE UTF8MB4_general_ci; | ||
| </code> | </code> | ||
| Line 87: | Line 93: | ||
| ==== create database object in meta data database(s) ==== | ==== create database object in meta data database(s) ==== | ||
| - | Now Create tables, ..... | + | Now create tables, ... \\ |
| You can run every part of the setup process separately by setting the proper option or | You can run every part of the setup process separately by setting the proper option or | ||
| + | |||
| ** run all at once with option "allobjects" ** | ** run all at once with option "allobjects" ** | ||
| Line 99: | Line 107: | ||
| in database niota_meta | in database niota_meta | ||
| - | <code> | + | <code bat setup_metadb_allobjects.cmd> |
| ...\bin>do_setup_metadb niota_meta ***** allobjects | ...\bin>do_setup_metadb niota_meta ***** allobjects | ||
| </code> | </code> | ||
| Line 114: | Line 122: | ||
| * format | * format | ||
| - | <code> | + | <code bat setup_metadb_allcontent.cmd> |
| ...\bin>do_populate_metadb niota_meta_c100 ***** allcontent | ...\bin>do_populate_metadb niota_meta_c100 ***** allcontent | ||
| </code> | </code> | ||
| - | <code> | + | <code bat setup_metadb_config.cmd> |
| ...\bin>do_populate_metadb niota_meta_c100 ***** config | ...\bin>do_populate_metadb niota_meta_c100 ***** config | ||
| </code> | </code> | ||
| - | |||
| Line 130: | Line 137: | ||
| - | <code> | + | <code bat setup_importdb.cmd> |
| ...\bin>do_setup_importdb information_schema ***** schemas | ...\bin>do_setup_importdb information_schema ***** schemas | ||
niota-docs/niota_install_meta_manually.1743672847.txt.gz · Last modified: 2025/07/17 14:11 (external edit)