[Koha] Foolproof backup suggestions

anjoze joseanjos at gmail.com
Wed Sep 18 03:13:05 NZST 2013

I use  a script with this name "automysqlbackup.sh.2.5"
It will make backup of koha database.
It will do the backup by day, by week and by month
In the example above it will do it to the /backup folder but you can change
it to any folder (Ex: a Dropbox folder to be uploaded automatically ;) )

*1- STEP:*
Change the Username, Password, Backupdir and email
Some of the fields have " others have ' and other have nothing. It is like

# Username to access the MySQL server e.g. dbuser

# Username to access the MySQL server e.g. password
# Host name (or IP address) of MySQL server e.g localhost

# List of DBNAMES for Daily/Weekly Backup e.g. "DB1 DB2 DB3"

# Backup directory location e.g /backups

# Mail setup
# What would you like to be mailed to you?
# - log   : send only log file
# - files : send log file and sql files as attachments (see docs)
# - stdout : will simply output the log to the screen if run manually.
# - quiet : Only send logs if an error occurs to the MAILADDR.

# Set the maximum allowed email size in k. (4000 = approx 5MB email [see

# Email Address to send mail to? (user at domain.com)
MAILADDR=*"mail at test.com"*

*2- STEP:*

On terminal:
sudo crontab -e

Insert the 2ª line:
# m h  dom mon dow   command
0 2 * * * /home/koha/./automysqlbackup.sh.2.5

Koha version: 	3.08.04
       - -
José Anjos
View this message in context: http://koha.1045719.n5.nabble.com/Foolproof-backup-suggestions-tp5770635p5770693.html
Sent from the Koha-general mailing list archive at Nabble.com.

More information about the Koha mailing list