Skip to content
This repository was archived by the owner on May 24, 2022. It is now read-only.

MySQL Cheat Sheet

Jump to bottom
zazi edited this page Oct 21, 2014 · 9 revisions

Currently, MySQL is choosen for providing the metadata repository.

  • Metadata repository schema:

    an image of the metadata repository schema

    The figure above is produced with SchemaSpy.

  • Initialize/reset metadata repository: see Server Install for initializing or resetting the database.

  • Backup metadata repository: 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 utilise the correct user name, password and database name (see also setup mysql).

For everyone

For users

For advanced users

For developers

Clone this wiki locally