Automatic backup (bash script)

omexlu

Hello,

I want to create a bash script that will be called by cronjob every day, do I have to do it like this?:

#!/bin/bash MAILCOW_BACKUP_LOCATION=/opt/mailcow-backups /opt/mailcow-dockerized/helper-scripts/backup_and_restore.sh backup all

Is there anything else that should be considered here?

Thanks in advance.

Proton2

MAILCOW_BACKUP_LOCATION must be a system variable
backup script must be run from directory where mailcow docker-compose is
it has to look like this:
#!/bin/bash cd /opt/mailcow-dockerized export MAILCOW_BACKUP_LOCATION=/opt/mailcow-backups /opt/mailcow-dockerized/helper-scripts/backup_and_restore.sh backup all

omexlu

Hi,

Thank you, works 🙂

jtdoank

how about adding

--delete-days 3

😄
btw thanks for the script too
I will integrate into my cronjob too

omexlu

Where have you add that flag? 🙂

jtdoank

please check this link
https://mailcow.github.io/mailcow-dockerized-docs/b_n_r_backup/

# Backup all, delete backups older than 3 days ./helper-scripts/backup_and_restore.sh backup all --delete-days 3

cheers 🍻

Mark

Hi everyone,

I tried the above script and found it working. I also noticed few errors like below.

[00] 2022-08-11 09:27:32 >> log scanned up to (24018784)
[00] 2022-08-11 09:27:32 Starting prep copy of non-InnoDB tables and files
[00] 2022-08-11 09:27:32 Starting rsync as: rsync -t . –files-from=/tmp/xtrabackup_rsyncfiles_pass1 /backup_mariadb/
rsync: link_stat “/var/lib/mysql/var/lib/mysql/ib_buffer_pool” failed: No such file or directory (2)
rsync error: some files/attrs were not transferred (see previous errors) (code 23) at main.c(1207) [sender=3.1.3]

Do I need to worry. If so, how do I fix that.

Thanks and Regards,
Mark.