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/25 10:13] admin |
niota-docs:niota_install_meta_manually [2025/07/17 14:11] (current) |
||
|---|---|---|---|
| Line 50: | 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 74: | 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 89: | 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 101: | 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 116: | 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 132: | 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.1745568814.txt.gz · Last modified: 2025/07/17 14:11 (external edit)