Automatically generates backups to an S3 Bucket

Supports both PostgreSQL and MariaDB databases.

Requires the following variables:

AWS_ACCESS_KEY_ID=
AWS_SECRET_ACCESS_KEY=
AWS_S3_BUCKET=
AWS_S3_REGION=
BACKUP_DATABASE_URL=
DATABASE_TYPE=postgres  # or 'mariadb'
SERVICE_NAME=
SENTRY_DSN=

For PostgreSQL:

postgresql://username:password@host:port/database

For MariaDB:

mysql://username:password@host:port/database

Download the zip file and uncompress it.

You'll have a file that ends in .sql (ex: my-backup.sql)

Run the following command on the same directory as the .sql file exists:

psql -U <username> -h <host> -d <DB-Name> -f my-backup.sql

Run the following command on the same directory as the .sql file exists:

mysql -u <username> -p -h <host> <DB-Name> < my-backup.sql