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 | XXXXX | password of user configured niota_setenv |
| #3 | option | restore,backup | choose 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\dump_<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.
The config file must exist in the ..\conf\mysqldump folder and must end with extension .conf
- do_manage_metadb_backup.sample
..\bin>do_manage_metadb.bat niota_meta ***** backup allobjects
-- tool printout ----------------------------------- DD.MM.YYYY 10:37:03,77 niota_meta is my universe DD.MM.YYYY 10:37:03,77 Warpcore Manager 1.0 is my master DD.MM.YYYY 10:37:03,77 admin_niota is my captain DD.MM.YYYY 10:37:03,77 backup is my mission using ../conf/mysqldump/allobjects.conf as guideline DD.MM.YYYY 10:37:03,77 3367 is my warp tunnel ----------------------------------- ... DD.MM.YYYY 10:37:04,68 ***INF: everything seems to be OK DD.MM.YYYY 10:37:04,69 ***INF: finished backup DD.MM.YYYY 10:37:04,69 ***INF: seems we are done!
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 extension .sql. Restore is done by MySQL tool 'mysql using the restore file as input file.
- do_manage_metadb_restore.sample
..\bin>do_manage_metadb.bat niota_meta ***** restore
niota-docs/niota_accessory_do_manage_metadb.1746780603.txt.gz · Last modified: 2025/07/17 14:11 (external edit)