David, I've put out a new post as I've imported the old Koha 3.0 database into the Koha 3.12 install. I've then tried to run the command to upgrade the database to 3.4 with nothing but errors. If I try to log into Koha 3.12 as an "old" staff user, it fails. If I log into Koha 3.12 with the provided username and password, Koha 3.12 does not recognize the "old" database and creates a "new" one (koha_library). Is there anyone that you know of that I could ask about this issue? Do you think I we should pay someone to transform the database? I've read and read everything that I can find, but nothing works. Phillip
From: pponchot@live.com To: david.nind@gmail.com; koha@lists.katipo.co.nz Date: Mon, 23 Dec 2013 01:37:22 -0800 Subject: Re: [Koha] Importing Koha Database to a new install
Thanks David, you've been very kind to help me. This gives me some idea of what to do and I'm not against trial and error which I will have time to do now that I figured out a way to recover the old server.
Date: Mon, 23 Dec 2013 13:55:05 +1300 Subject: Re: [Koha] Importing Koha Database to a new install From: david.nind@gmail.com To: pponchot@live.com; koha@lists.katipo.co.nz
Hi Phillip.
I've not upgraded from a pre-3.04 version of Koha before, so can only go on what is on the wiki/install instructions. Someone else on the list may be able to confirm, or not, whether this is the correct way..
You would do this after you have loaded the old database into your new server i.e. you've setup the new version and it is working, delete the database (or rename), load in the database dump from your old version.
I think the script is run after you have accessed the administration site (the intranet) for the first time, as it needs to run some other database updates.
The instructions mentioned are here:
http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=INSTALL;hb=HEAD
It also looks like there is a handy script to do this for you when you have installed by packages - koha-upgrade-to-3.4 . See: http://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages#Upgrade_Instru... http://wiki.koha-community.org/wiki/Commands_provided_by_the_Debian_packages...
On 23 December 2013 09:03, Phillip Ponchot <pponchot@live.com> wrote:
David,
I'm new to Koha and to the Koha site so I can't seem to find the instructions from 3.0 to 3.4. My question would be how I would do these steps.
One question I have is should I load the old database into the new version and then run the steps in 101 and 102 or do I do this before I export the database?
Could you send me the link to the instructions that you found below?
Date: Mon, 23 Dec 2013 07:58:35 +1300 Subject: Re: [Koha] Importing Koha Database to a new install From: david.nind@gmail.com
To: pponchot@live.com CC: koha@lists.katipo.co.nz
Hi Phillip.
I think I've figured out what's up. I managed to determine that the Koha database is from Koha version 3.00.00.107 and the version that I've installed by default is 3.14.00.000. This means that the database is extremely out of date and can not be "imported" without transforming some of the data.
From the manual installation instructions when updating from a 3.0-3.3 to version 3.4 or later:
96 Koha 3.4.x or later no longer stores items in biblio records. 97 If you are upgrading from an older version ou will need to do the
98 following two steps, they can take a long time (several hours) to 99 complete for large databases 100 101 misc/maintenance/remove_items_from_biblioitems.pl --run
102 misc/migration_tools/rebuild_zebra.pl -b -r
http://git.koha-community.org/gitweb/?p=koha.git;a=blob;f=INSTALL;hb=HEAD
Also see 8-): http://lists.katipo.co.nz/pipermail/koha/2013-December/038228.html
-- David Nind | david.nind@gmail.com PO Box 12367, Thorndon, Wellington, New Zealand 6144 h. +64 4 9720 600 | m. +64 21 0537 847 | w. +64 4 8906 098
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha