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? ([email protected]) MAILADDR=*"[email protected]"* *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. _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
