Re: [Koha-devel] incremental backup of the DB

2015-11-18 Thread 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

Re: [Koha-devel] Indexes of Physical presentation

2015-11-18 Thread Fridolin SOMERS
Hie Katrin, 'physical presentation' is just the name of one of the search fields in advanced search. In intranet you must click on 'Coded information filters' to see it. I don't know if it is UNIMARC-only, can you check with the demo websites ? Best regards. Le 10/11/2015 23:14, Katrin Fisch

Re: [Koha-devel] Indexes of Physical presentation

2015-11-18 Thread Bernardo Gonzalez Kriegel
It's UNIMARC specific :) -- Bernardo Gonzalez Kriegel bgkrie...@gmail.com On Wed, Nov 18, 2015 at 1:15 PM, Fridolin SOMERS < fridolin.som...@biblibre.com> wrote: > Hie Katrin, > > 'physical presentation' is just the name of one of the search fields in > advanced search. > In intranet you must c

Re: [Koha-devel] incremental backup of the DB

2015-11-18 Thread Paul A
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

Re: [Koha-devel] Getting an IP address for a koha server

2015-11-18 Thread Michael Hafen
I think the best way would be to add an address reservation in the DHCP service for your Koha server. In practice having an IP address that changes on a web server doesn't work well. A reservation in DHCP should guarantee that the Koha server gets a 'dynamic' address that is always the same. On

Re: [Koha-devel] Indexes of Physical presentation

2015-11-18 Thread Katrin Fischer
Ah, that explains, thx Bernardo! :) Am 18.11.2015 um 17:49 schrieb Bernardo Gonzalez Kriegel: > It's UNIMARC specific :) > > -- > Bernardo Gonzalez Kriegel > bgkrie...@gmail.com > > On Wed, Nov 18, 2015 at 1:15 PM, Fridolin SOMERS > mailto:fridolin.som...@biblibre.c

Re: [Koha-devel] incremental backup of the DB

2015-11-18 Thread Robin Sheat
Paul A schreef op wo 18-11-2015 om 12:15 [-0500]: > However, the original post asked about "incremental backup" and I > assumed > that this referred to MySQL "enterprise backup" > because I > am > unaware of an incremental *dump*. With t

Re: [Koha-devel] Problematic Zebra Charmaps Equivalences

2015-11-18 Thread David Cook
Yikes, that’s not good. That would be great if you could investigate further, and let us know how it goes, and let Indexdata know as well. David Cook Systems Librarian Prosentient Systems 72/330 Wattle St, Ultimo, NSW 2007 From: koha-devel-boun...@lists.koha-community.org [mailto:koha-

Re: [Koha-devel] incremental backup of the DB

2015-11-18 Thread Paul A
At 09:51 AM 11/19/2015 +1300, Robin Sheat wrote: Paul A schreef op wo 18-11-2015 om 12:15 [-0500]: > However, the original post asked about "incremental backup" and I > assumed > that this referred to MySQL "enterprise backup" > because I

Re: [Koha-devel] incremental backup of the DB

2015-11-18 Thread Robin Sheat
Paul A schreef op wo 18-11-2015 om 17:49 [-0500]: > Very interesting, can you share more details? Not really, I didn't implement it. But essentially it provides an offsite database replicant that can then be backed up using snapshotting or whatever. I think regularly dumping a running database wo

[Koha-devel] E noho rā, Koha

2015-11-18 Thread Robin Sheat
Hi, Koha folks. Tomorrow is my last day at Catalyst, and the end of my last week in New Zealand. From December, I'm starting a new job that is located only 1,450km distance from as far away as it is possible to get from Wellington on earth. That is, in Amsterdam*. It's been a pleasure meeting t

Re: [Koha-devel] incremental backup of the DB

2015-11-18 Thread David Cook
I agree with Robin. I've seen another system that does database dumps during the middle of the day while the database server is running, and the increased server load is quite significant. I'm also guessing that locking takes place as sometimes the load will skyrocket during this time. Besides t

Re: [Koha-devel] E noho rā, Koha

2015-11-18 Thread David Cook
Congratulations on the new job! We're sorry to see you go, but hope that you enjoy Amsterdam! It was a pleasure meeting you in Tasmania, and sharing the Oceanic timezone with you on IRC! David Cook Systems Librarian Prosentient Systems 72/330 Wattle St, Ultimo, NSW 2007 > -Original Messag

Re: [Koha-devel] incremental backup of the DB

2015-11-18 Thread Mark Tompsett
Greetings, That's why when I was running Koha 3.6.x on a machine with only 512MB RAM with no swap and 20GB disk space, I would after hours: - restart mysql - shut off apache - backup - turn on apache This would free up some much needed RAM so that the backup would work. :) Now we've (both Koha

Re: [Koha-devel] E noho rā, Koha

2015-11-18 Thread Marcel de Rooy
Amsterdam is okay with me, but how sad to see you go. Success on the new job. Yes, you have to come to the Rijksmuseum. Van: koha-devel-boun...@lists.koha-community.org [koha-devel-boun...@lists.koha-community.org] namens Robin Sheat [ro...@catalyst.net.n