VuFind Software is going to organize a training course on Digital Library. If you are interested you are kindly requested to fill-up the* on-line form <https://forms.gle/Ur8ERJ23MX2MpYrXA>* . For details of the course click the *brochure*. <https://drive.google.com/file/d/1xf4obi3RxExVvwuvrefIQL6AsP_S5HLu/view?usp=sharing> The last date of filling application form is 20th September, 2020. The seat is limited to 25 participants. Based on the application, the successful participants will be announced on 25th September, 2020 and the link for online payment will also be sent to the successful participants in their email. The training course will start from 5th October , 2020. Prof. Mohan Raj Pradhan, Ph. D. Training Coordinator VuFindSoftware web: training.vufnd.org On Thu, Sep 10, 2020 at 5:46 AM <koha-request@lists.katipo.co.nz> wrote:
Send Koha mailing list submissions to koha@lists.katipo.co.nz
To subscribe or unsubscribe via the World Wide Web, visit https://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request@lists.katipo.co.nz
You can reach the person managing the list at koha-owner@lists.katipo.co.nz
When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..."
Today's Topics:
1. Upgrade from Koha 3.08.07 (Nigel Titley) 2. Re: Upgrade from Koha 3.08.07 (Nigel Titley) 3. Re: Upgrade from Koha 3.08.07 (Nigel Titley) 4. Re: Upgrade from Koha 3.08.07 (Nigel Titley) 5. Re: Upgrade from Koha 3.08.07 (Alex Shepherd)
----------------------------------------------------------------------
Message: 1 Date: Wed, 9 Sep 2020 15:34:04 +0100 From: Nigel Titley <nigel@titley.com> To: Koha <Koha@lists.katipo.co.nz> Subject: [Koha] Upgrade from Koha 3.08.07 Message-ID: <267bdf94-19e3-3067-3807-a35cdfd4d013@titley.com> Content-Type: text/plain; charset=utf-8
I'm running an extremely antique version of Koha 3.08.07 on Debian Squeeze.
For various reasons (mainly the fact that the system is enormously stable) nothing has been upgraded for a long while but it's getting to the point where I need to upgrade it. I'm planning at the same time to move Koha off onto a new system running the latest Ubuntu LTS. I'm happy with installing a brand-new Koha but how do I go about transferring the data. I've found instructions for shifting the database but will the database schema upgrade work with that huge a jump? It's not a huge library, just a couple of thousand books.
Thanks for any help that anyone can offer.
Nigel
------------------------------
Message: 2 Date: Wed, 9 Sep 2020 15:53:05 +0100 From: Nigel Titley <nigel@titley.com> To: koha@lists.katipo.co.nz Subject: Re: [Koha] Upgrade from Koha 3.08.07 Message-ID: <bef5964a-be28-c06f-cf44-3cccb32a4c07@titley.com> Content-Type: text/plain; charset=utf-8
On 09/09/2020 15:34, Nigel Titley wrote:
I'm running an extremely antique version of Koha 3.08.07 on Debian Squeeze.
For various reasons (mainly the fact that the system is enormously stable) nothing has been upgraded for a long while but it's getting to the point where I need to upgrade it. I'm planning at the same time to move Koha off onto a new system running the latest Ubuntu LTS. I'm happy with installing a brand-new Koha but how do I go about transferring the data. I've found instructions for shifting the database but will the database schema upgrade work with that huge a jump? It's not a huge library, just a couple of thousand books.
Thanks for any help that anyone can offer.
And answering my own question, it looks like it might be possible to export the book inventory in MARC format and the Patrons as a CSV file. And possibly the transactions in an offline format? If the worst comes to the worst I can lose the transactions.
Does that sound like a plan?
Nigel
------------------------------
Message: 3 Date: Wed, 9 Sep 2020 17:24:23 +0100 From: Nigel Titley <nigel@titley.com> To: koha@lists.katipo.co.nz Subject: Re: [Koha] Upgrade from Koha 3.08.07 Message-ID: <aec68d67-8021-7d5e-22d6-ba8ccfea9df0@titley.com> Content-Type: text/plain; charset=utf-8
And answering my own question, it looks like it might be possible to export the book inventory in MARC format and the Patrons as a CSV file. And possibly the transactions in an offline format? If the worst comes to the worst I can lose the transactions.
Does that sound like a plan?
And answering my own question again it looks like that all I have to do is dump the database on the old machine, copy it across and install it on the new machine. The schema upgrade *should* be able to cope as I'm running a koha instance later than 3.4
Nigel
------------------------------
Message: 4 Date: Wed, 9 Sep 2020 18:13:32 +0100 From: Nigel Titley <nigel@titley.com> To: koha@lists.katipo.co.nz Subject: Re: [Koha] Upgrade from Koha 3.08.07 Message-ID: <b432b667-4107-5bb4-d014-721fee640565@titley.com> Content-Type: text/plain; charset=utf-8
On 09/09/2020 17:24, Nigel Titley wrote:
And answering my own question, it looks like it might be possible to export the book inventory in MARC format and the Patrons as a CSV file. And possibly the transactions in an offline format? If the worst comes to the worst I can lose the transactions.
Does that sound like a plan?
And answering my own question again it looks like that all I have to do is dump the database on the old machine, copy it across and install it on the new machine. The schema upgrade *should* be able to cope as I'm running a koha instance later than 3.4
And this indeed worked... so everyone please ignore my witterings. The procedure I followed was
1. Install latest koha on the new machine 2. Use mysqldump to dump the whole koha database on the old machine 3. Copy across to new machine 4. Use "koha-create --create-db <library>" to create a koha instance on the new machine 5. Drop the new empty database <koha_library> created by step 4 6. Create a new empty database <koha_library> 7. Use mysql to import the dump you made in step 2 into <koha_library> 8. Run koha-upgrade-schema <library> 9. Run koha-rebuild-zebra -v -f <library> 10. Restart apache (possibly not necessary but doesn't do any harm)
I now seem to have a fully functional new koha on a new machine
Thanks everyone (I know no one said anything but you were all there in spirit)
Nigel
------------------------------
Message: 5 Date: Thu, 10 Sep 2020 09:16:17 +1200 From: Alex Shepherd <kiwi64ajs@gmail.com> To: Nigel Titley <nigel@titley.com> Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Upgrade from Koha 3.08.07 Message-ID: <94140BC3-13A9-445F-94E3-A6C9E48F92B5@gmail.com> Content-Type: text/plain; charset=utf-8
Thanks Nigel for reporting your success. I have an upgrade from Ubuntu 16.04 / Koha 17.11 and wonder about such things. In need to clone my VM and try and upgrade but I’ve been putting t off...
Your success of a much harder upgrade is very encouraging.
Regards Alex Shepherd
Sent from my iPad
On 10/09/2020, at 5:14 AM, Nigel Titley <nigel@titley.com> wrote:
On 09/09/2020 17:24, Nigel Titley wrote:
And answering my own question, it looks like it might be possible to export the book inventory in MARC format and the Patrons as a CSV file. And possibly the transactions in an offline format? If the worst comes to the worst I can lose the transactions.
Does that sound like a plan?
And answering my own question again it looks like that all I have to do is dump the database on the old machine, copy it across and install it on the new machine. The schema upgrade *should* be able to cope as I'm running a koha instance later than 3.4
And this indeed worked... so everyone please ignore my witterings. The procedure I followed was
1. Install latest koha on the new machine 2. Use mysqldump to dump the whole koha database on the old machine 3. Copy across to new machine 4. Use "koha-create --create-db <library>" to create a koha instance on the new machine 5. Drop the new empty database <koha_library> created by step 4 6. Create a new empty database <koha_library> 7. Use mysql to import the dump you made in step 2 into <koha_library> 8. Run koha-upgrade-schema <library> 9. Run koha-rebuild-zebra -v -f <library> 10. Restart apache (possibly not necessary but doesn't do any harm)
I now seem to have a fully functional new koha on a new machine
Thanks everyone (I know no one said anything but you were all there in spirit)
Nigel
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------
Subject: Digest Footer
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------
End of Koha Digest, Vol 179, Issue 10 *************************************