At 05:06 PM 11/18/2015 +0100, Fridolin SOMERS wrote:
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
For "dump" you are obviously quite correct that compression, size and speed
can be tweaked.
However, the original post asked about "incremental backup" and I assumed
that this referred to MySQL "enterprise backup"
<http://dev.mysql.com/doc/mysql-enterprise-backup/4.0/en/> because I am
unaware of an incremental *dump*. With the "Enterprise backup" we found it
impossible to compress the incrementals, but YMMV.
Best -- Paul
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
[email protected]
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
[email protected]
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
[email protected]
_______________________________________________
Koha-devel mailing list
[email protected]
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/
---
Maritime heritage and history, preservation and conservation,
research and education through the written word and the arts.
<http://NavalMarineArchive.com> and <http://UltraMarine.ca>
_______________________________________________
Koha-devel mailing list
[email protected]
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/
