Introduction

This is a simple Python script to back up databases. Right now, it only backs up MySQL databases, but 'maybe maybe' in the future we might want to extend to RPM and Postgres as well.

How it works

It is assumed that an environment file dbbackupr2.env exists. An example of the file can be found in this repo as dbbackupr2.env

The script makes a list of all databases existing on the MySQL host, does a mysqldump per database, and then makes it into a bzip2 archive, to save space. The resulting files, that look like myql-my_database-2024-07-09.bz2, are stored in BACKUP_DIR.

Old database backups are retained for MYSQL_KEEP_DAYS days.

It is assumed that mysqldump and bzip2 are available on the sytem. No checks are done, so the script simply raises a gory Exception when these CLI tools cannot be found.

It is also assumed that the MySQL connnection has already been defined via the file ~/.my.cnf:

[client]
host=<mysql hostname>
user=<mysql username>
password=<mysql password>
default-character-set = utf8mb4

Builds

Standalone binary

One beautiful day, I would like to see this script being built into a binary with the help of pyinstaller,

Running pyinstaller, when a .venv has been created.

pyinstaller --onefile --paths=.venv/lib/python3.10/site-packages dbbackupr2.py

Running with a .venv

Setup your .venv, install the requirements, and run. Maybe instructions coming soon...

Docker build

Please see the included Dockerfile. After building, you can run the job as follows

docker run -it --rm --env-file /path/to/dbbackupr2.env -v /path/to/backup:/dbbackup -v /path/to/.my.cnf:/root/.my.cnf myuser/dbbackupr2 

File paths:

• /path/to/dbbackupr2.env (your local environment file)
• /path/to/backup (where your backups are stored)
• /path/to/.my.cnf (MySQL credentials)