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 <[email protected]> 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 > [email protected] > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

