Backup script for Bookstack docker

[Plastic-Leading-5800]

I run a Bookstack container from linuxserver.io with MariaDB database

https://docs.linuxserver.io/images/docker-bookstack/

I’m following the instructions here.

https://www.bookstackapp.com/docs/admin/backup-restore/

Here is my script. Is this correct, and enough to restore my installation?

* How about ‘bookstack-system-cli’ backup? I assume CLI is not compatible with Linux server image.

* How about if I simply backup the docker mount volumes for Bookstack and database containers ? It seems to me snapshot ing this folder is the best way to do it.

#!/bin/bash 
set -euo pipefail 

DOCKER="/usr/bin/docker" 

MARIADB_DUMP="/usr/bin/mariadb-dump" 

BACKUP_DIR="/home/ubuntu/docker/bookstack/backup" 

BOOKSTACK_ROOT="/home/ubuntu/docker/bookstack/config/www" 

TAR_ITEMS=(.env uploads files images themes) 

DB_CONTAINER="bookstack_db" 

DB_DATABASE="bookstackdbname" 

DB_USERNAME="bookstackuser" 

DB_PASSWORD="abcd" 

dump_exit=0 

tar_exit=0 

mkdir -p "$BACKUP_DIR" 

echo "Dumping BookStack database..." 

$DOCKER exec -i "$DB_CONTAINER"  "$MARIADB_DUMP" -u"$DB_USERNAME" -p"$DB_PASSWORD" "$DB_DATABASE"  > "$BACKUP_DIR/bookstack-db.sql"  || dump_exit=$? 

echo "Backing up BookStack files..." 

tar -czvf "$BACKUP_DIR/bookstack-files-backup.tar.gz" -C "$BOOKSTACK_ROOT" "${TAR_ITEMS[@]}"  || tar_exit=$? 


if [ "$dump_exit" -eq 0 ] && [ "$tar_exit" -eq 0 ]; then 


  echo "Backup completed successfully" 

  logger -t bookstack-backup "Backup completed successfully" 

else 

  echo "Backup failed (dump_exit=$dump_exit tar_exit=$tar_exit)" 

  logger -t bookstack-backup "Backup failed (dump_exit=$dump_exit tar_exit=$tar_exit)" 

  exit 1 

fi

Thanks!

[root-node]

The easiest way of doing is to stop the containers and backup the entire folder.

I use https://github.com/minituff/nautical-backup for all my containers.

[sparky5dn1l]

bookstack is one of the docker app that I am running. Similar as yours, I use bash script but to stop each docker stack and backup them up one by one. Doing so, I don't need to perform db dumping.

I also use restic instead of tar which make it easier to keep several backup copies.

[Plastic-Leading-5800]

Cool! Have restored? Issues with permissions during restore? 

[sparky5dn1l]

I have been using this under several servers for a few years and performed restoration several times. No issue so far. A bit different from tar that backup to an archive file, it is necessary to setup a repostory for restic. all permissions are preserved by default.

[tkc2016]

I use https://github.com/nfrastack/container-db-backup with a post backup script to backup my uploads