db/README.md

mariadb

Setup

Setup the DB Root Password

• cp .env.template .env && vi .env
• The root password in .env gets stored in the DB during the intial container deployment. Changes of the file in a later stage have no effect.
• The password can be changed later on only using mysqladmin' -u root password 'new-password'.

Maintenance

• Create a new DB by running .utils/create_db.sh <database_name>
  • <database_name> is the name and user of the new DB
  • The password is set randomly and stored with further details in db_defintion__<database_name>.txt.
• List DBs by running ./utils/db_names.sh
• Delete a DB by running .utils/delete_db.sh <database_name>
• For backup see the container db_sqldump
• Upgrade docker exec db sh -c 'mariadb-upgrade -p$MYSQL_ROOT_PASSWORD
• Restore docker exec db sh -c 'mysql -p$MYSQL_ROOT_PASSWORD < /mnt/backup/backupfile.sql'