[Koha] Koha Digest, Vol 179, Issue 10

mohan pradhan pradhmohan at gmail.com
Fri Sep 11 02:54:33 NZST 2020


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 at lists.katipo.co.nz> wrote:

> Send Koha mailing list submissions to
>         koha at 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 at lists.katipo.co.nz
>
> You can reach the person managing the list at
>         koha-owner at 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 at titley.com>
> To: Koha <Koha at lists.katipo.co.nz>
> Subject: [Koha] Upgrade from Koha 3.08.07
> Message-ID: <267bdf94-19e3-3067-3807-a35cdfd4d013 at 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 at titley.com>
> To: koha at lists.katipo.co.nz
> Subject: Re: [Koha] Upgrade from Koha 3.08.07
> Message-ID: <bef5964a-be28-c06f-cf44-3cccb32a4c07 at 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 at titley.com>
> To: koha at lists.katipo.co.nz
> Subject: Re: [Koha] Upgrade from Koha 3.08.07
> Message-ID: <aec68d67-8021-7d5e-22d6-ba8ccfea9df0 at 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 at titley.com>
> To: koha at lists.katipo.co.nz
> Subject: Re: [Koha] Upgrade from Koha 3.08.07
> Message-ID: <b432b667-4107-5bb4-d014-721fee640565 at 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 at gmail.com>
> To: Nigel Titley <nigel at titley.com>
> Cc: koha at lists.katipo.co.nz
> Subject: Re: [Koha] Upgrade from Koha 3.08.07
> Message-ID: <94140BC3-13A9-445F-94E3-A6C9E48F92B5 at 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 at 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 at lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> ------------------------------
>
> End of Koha Digest, Vol 179, Issue 10
> *************************************
>


More information about the Koha mailing list