This is an old revision of the document!
Backup or restore a metadata database with MySQL system programs.
| 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 | thisabc | prefix of the extra-config file |
With this option a backup file is created by using tool mysqldump. The backup is written to folder dbdump\database\backup_<metadataDB>.sql.
..\bin>do_manage_metadb.bat niota_meta ***** backup
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
..\bin>do_manage_metadb.bat niota_meta ***** restore