[Koha-devel] incremental backup of the DB

[Fridolin SOMERS]

You may use gzip compression.
I suggest with level 3 (default is 6) to get a fast yet very compressed 
file :
mysqldump my_koha_db | gzip -3 > my_koha_dump.sql.gz

Le 17/11/2015 23:24, Paul A a écrit :
> 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/
>
> _______________________________________________
> 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/

-- 
Fridolin SOMERS
Biblibre - Pôles support et système
fridolin.somers at biblibre.com