User Tools
Sidebar
niota-docs:niota_accessory_do_manage_metadb
This is an old revision of the document!
Table of Contents
do_manage_metadb
Backup or restore a metadata database with MySQL system programs.
parameters
| No | Name | sample value | description |
|---|---|---|---|
| #1 | metadataDB | niota_meta_c100 | Name of the metadata database to handle |
| #2 | password | * | password of user configured niota_setenv |
| #3 | option | restore,backup | chose only one option! |
| #4 | config | allobjects,customdata,objectsonly | name of the extra-config file located in folder conf\mysqldump |
option backup
With this option a backup file is created by using tool mysqldump. The backup is written to folder dbdump\database\backup_<metadataDB>.sql.
With option backup you can also set a config file, where you can set all needed options for your backup. For further details which options are available please read MySQL mysqldump doku.
- do_manage_metadb_backup.sample
..\bin>do_manage_metadb.bat niota_meta ***** backup
option restore
With this option you can restore a given backup/restore file to an existing MySQL schema. The restore file is read from folder dbrestore\database\restore_<metadataDB>.sql.
Please mind this naming conventions. The name of the restore file must start with restore_ followed by the name of the target schema and the extions .sql
- do_manage_metadb_restore.sample
..\bin>do_manage_metadb.bat niota_meta ***** restore
niota-docs/niota_accessory_do_manage_metadb.1746779594.txt.gz · Last modified: 2025/07/17 14:11 (external edit)