Bookstack Backup to S3

dbeato

Since I have been using bookstack more and more and while I do VM backups, I just wanted to setup backup externally to S3.
The UI or system doesn't have a way to do database backups from the GUI or schedule it. So I created my MariaDB backup to S3 as below and wanted to share and open to change as well.

find /sql0-backups/ -type f -iname '*.sql' -mtime +1 -delete
USER=usernanme
PASS="password"
DB=bookstack
DATE=$(date +%Y-%m-%d-%H-%M)
mysqldump -u $USER -p$PASS $DB > /sql-backups/backup-$DATE.sql
aws s3 cp /sql-backups s3://bucket-name/ --endpoint-url=https://s3.wasabisys.com --recursive

Alex Jones

Thanks!

dafyre

Set that up in cron to run it on a schedule.

dbeato

@dafyre said in Bookstack Backup to S3:

Set that up in cron to run it on a schedule.

yes, I have that going.

wrx7m

@dbeato Are you running bookstack in AWS?

dbeato

@wrx7m said in Bookstack Backup to S3:

@dbeato Are you running bookstack in AWS?

Not at the moment. I am just backing up to S3.

wrx7m

@dbeato said in Bookstack Backup to S3:

@wrx7m said in Bookstack Backup to S3:

@dbeato Are you running bookstack in AWS?

Not at the moment. I am just backing up to S3.

Look at Wasabi for S3 compatible object storage. Significantly cheaper.

scottalanmiller

@wrx7m said in Bookstack Backup to S3:

@dbeato said in Bookstack Backup to S3:

@wrx7m said in Bookstack Backup to S3:

@dbeato Are you running bookstack in AWS?

Not at the moment. I am just backing up to S3.

Look at Wasabi for S3 compatible object storage. Significantly cheaper.

Yup, can't think of any reason to use S3 unless you are hosted on AWS and aren't using it for backup but for production storage. And even then, not the majority of the time. S3 is too expensive and doesn't really offer anything except locality that is of any specific value. B2 and Wasabi beat it a lot.

dbeato

@wrx7m said in Bookstack Backup to S3:

@dbeato said in Bookstack Backup to S3:

@wrx7m said in Bookstack Backup to S3:

@dbeato Are you running bookstack in AWS?

Not at the moment. I am just backing up to S3.

Look at Wasabi for S3 compatible object storage. Significantly cheaper.

Sorry, If you see my script. It is pointing to Wasabi so yes I am using that instead.

dbeato

@scottalanmiller said in Bookstack Backup to S3:

@wrx7m said in Bookstack Backup to S3:

@dbeato said in Bookstack Backup to S3:

@wrx7m said in Bookstack Backup to S3:

@dbeato Are you running bookstack in AWS?

Not at the moment. I am just backing up to S3.

Look at Wasabi for S3 compatible object storage. Significantly cheaper.

Yup, can't think of any reason to use S3 unless you are hosted on AWS and aren't using it for backup but for production storage. And even then, not the majority of the time. S3 is too expensive and doesn't really offer anything except locality that is of any specific value. B2 and Wasabi beat it a lot.

Sorry, I posted this as S3 but I should change it to Wasabi. It is the same Idea for both.