[Koha-devel] incremental backup of the DB

[Paul A]

At 02:34 AM 11/18/2015 +0530, Indranil Das Gupta wrote:
>Hi all,
>
>I'm facing a situation that between full backups, I would like to take
>incremental backups. Anyone have played with mysql incremental backup
>and Koha? any known issues?

Yup -- [probably, depends, no compression] and if you ever "restore" you'll 
get back all your deletes since the last full backup...

We just clean the MySQL db a couple of times a day and dump it -- takes 
2104ms for a 754 Meg dump, so there's really no down time at all. Write 
some sort of [bash] script along the following lines for your Koha user in 
/usr/share/koha:

./bin/cronjobs/cleanup_database.pl --import 1 &&
./bin/cronjobs/cleanup_database.pl --sessions &&
./bin/cronjobs/cleanup_database.pl --logs 10 &&
./bin/cronjobs/cleanup_database.pl --zebraqueue 1 &&
mysqldump --user=whomever --password=whatever your_koha_db > 
/mnt/data7/backup/your_koha_db_dump_[rotate_number].sql

Prepend
./bin/cronjobs/cleanup_database.pl --mail -v &&
if required, vary your variables 'au goût du jour' and bingo...

Best -- Paul


>thanks in advance
>
>--
>Indranil Das Gupta
>
>Phone : +91-98300-20971
>Blog    : http://indradg.randomink.org/blog
>IRC      : indradg on irc://irc.freenode.net
>Twitter : indradg
>
>-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-
>Please exchange editable Office documents only in ODF Format. No other
>format is acceptable. Support Open Standards.
>
>For a free editor supporting ODF, please visit LibreOffice -
>http://www.documentfoundation.org
>_______________________________________________
>Koha-devel mailing list
>Koha-devel at lists.koha-community.org
>http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>website : http://www.koha-community.org/
>git : http://git.koha-community.org/
>bugs : http://bugs.koha-community.org/