[Koha] Foolproof backup suggestions

[anjoze]

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
that.

# Username to access the MySQL server e.g. dbuser
USERNAME=*mysql_root_user*

# Username to access the MySQL server e.g. password
PASSWORD=*'password_of_mysql_root'
*
# Host name (or IP address) of MySQL server e.g localhost
DBHOST=localhost

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

# Backup directory location e.g /backups
BACKUPDIR=*"/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.
MAILCONTENT="stdout"

# Set the maximum allowed email size in k. (4000 = approx 5MB email [see
docs])
MAXATTSIZE="4000"

# 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.