[Koha] How to run cron to autobackup of koha database (only sql) ?
SATISH
lis4satish at gmail.com
Tue Sep 20 16:36:57 NZST 2016
Dear All,
I have two questions regarding 1) cronjob and 2) time stamp
I would like to know, How to setup cronjob to autobackup of database sql
daily ?(before we close the library)
Till now, I have enabled Cronjob with
localhost:~# cd /usr/share/koha/bin/cronjobs
localhost:~# crontab -u root crontab.example
/usr/share/koha/bin/cronjobs shows - crontab.example and it has all the
required instructions for the cron.
I wanted to autobackup of koha db (example: at 5:15 pm daily before library
closes)
I tried with, following steps.
1. added in crontab -e
#ADDED BY SATISH FOR DAILY BACKUP AT 5.15 PM DAILY
15 17 * * * mysqldump -uroot -pmysqlrootpassword dbname | gzip -9 >
/home/satish/Dropbox/dbname.sql.gz
When I check the dbsize, it is "zero". Therefore, It is not working!
2. by default Koha has /etc/cron.daily
koha-run-backups --days 2 --output /var/spool/koha
But, It backups when system boots every morning.
how to schedule the time for the same?
And Koha-run-backups has all the sql and config files backup. But I wanted
have only complete db (sql).
And also, our library works from 9:30 am to 5.30 pm on week days and
9:30-1:30 pm on every Saturday. (Desktop machine) as server, will be
shutdown in the evening everyday until library receives a dedicated server
machine.
Currently, after setting up- Postfix mail agent, overdue message, advance
due notice, check in, check out , new registration notice all are working
fine,. but I wanted to setup timings as per the open and closing hours.
The checkout Message includes (Notices Section):
example Due Date: 20/09/2016 23:59
How to change the Due Date time from 23:59 to 5.30 pm or 17:30 ?
My Koha Details are:
Version -16.5.01 (upgraded from 3.16.00)
OS: Ubuntu - 14.04 server edition (upgraded from 12.04)
Install method - Packages
Kindly share your best practices?
with thanks
Satish MV
Librarian
Govt. Engineering College, Hassan
Karnataka.
--
More information about the Koha
mailing list