On Sep 19, 2016 10:37 PM, "SATISH" <lis4sat...@gmail.com> wrote:
> I wanted to autobackup of koha db (example: at 5:15 pm daily before
> 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 >
> When I check the dbsize, it is "zero". Therefore, It is not working!
The mysqldump syntax looks correct.
What user are you running the crontab under?
My inclination would be to run the backup under the instance user, using
the database user in $KOHA_CONF.
Crontabs can get picky about things like $PATH being undefined, so you may
need to specify the full path of mysqldump. Also, they look like they use
shell syntax, but you should consult 'man 8 crontab' for differences.
I'm on my phone, so I can't look up the exact syntax that I use for
inserting timestamps into file names, or how that interacts with crontab. I
can tell you that I use 'date' in back-ticks, but I'm not sure which
arguments I used, whether crontab supports back-ticks (if not, just wrap
your call to mysqldump inside a small shell script, and call the script
from the crontab).
Koha mailing list http://koha-community.org