MySQL Cheat Sheet

Currently, MySQL is choosen for providing the metadata repository.

Metadata Repository Schema

The figure below is produced with SchemaSpy (that may be used to create interactive pages to visualize and explore the database schema).

Initialize/Reset Metadata Repository DB

See Server Install for initializing or resetting the database.

Backup Metadata Repository DB

to create a data dump, run the command

mysqldump -udmp -pdmp --no-create-info --no-create-db --skip-triggers --skip-create-options --skip-add-drop-table --skip-lock-tables --skip-add-locks -B dmp > dswarm_dump.sql

Hint: remember to use correct user name, password and database name (see also setup mysql).