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:50] admin |
niota-docs:niota_install_meta_manually [2025/07/17 14:11] (current) |
||
|---|---|---|---|
| Line 57: | Line 57: | ||
| <code bat setup_metadb.cmd> | <code bat setup_metadb.cmd> | ||
| - | ...\bin>do_setup_metadb sys **** schemas | + | ...\bin>do_setup_metadb sys ***** schemas |
| </code> | </code> | ||
| Line 78: | 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 93: | 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 105: | 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 120: | 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 136: | Line 137: | ||
| - | <code> | + | <code bat setup_importdb.cmd> |
| ...\bin>do_setup_importdb information_schema ***** schemas | ...\bin>do_setup_importdb information_schema ***** schemas | ||