Database Backups

It is recommended to create regular backups of the RIPS database in case projects are deleted or corrupted by accident.

Create backups

To create a database backup, simply call the command mysqldump_rips inside of the rips_db Docker container. The command mysqldump_rips is a wrapper around mysqldump and handles the database authentication. The output of mysqldump is send to stdout. It can be saved into a file inside of the backups directory (default: /var/rips3/backups) by running the following commands.

/opt/rips/rips3.py rips:exec db bash
cd /backups
mysqldump_rips api > backup.sql

Restore backups

To restore database backups, the command mysql_rips can be used. Similar to mysqldump_rips this command is a wrapper around mysql that handles the authentication.

/opt/rips/rips3.py rips:exec db bash
cd /backups
mysql_rips api < backup.sql