Re: [Koha] How to run cron to autobackup of koha database (only sql) ?

2016-09-21 Thread Fridolin SOMERS 

Hie,

I advice you to store user and password for mysql in ~/.my.cnf.
So you can simply call as koha user : mysqldump dbname > ...

Example :
[client]
user=kohaadmin
password=katikoan
host=localhost

[mysql]
default-character-set=utf8
database=kohadb

In this case mysql leads to a connexion with kohadb selected.
Not possible for mysqldump, db name must be specified.

Regards,

Le 21/09/2016 à 14:01, Barton Chittenden a écrit :

On Sep 19, 2016 10:37 PM, "SATISH"  wrote:


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!



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
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha



--
Fridolin SOMERS
Biblibre - Pôles support et système
fridolin.som...@biblibre.com
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] How to run cron to autobackup of koha database (only sql) ?

2016-09-21 Thread Barton Chittenden 
On Sep 19, 2016 10:37 PM, "SATISH"  wrote:

> 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!
>

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
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha