Re: [Koha] Importing Koha Database to a new install
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
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
At 01:37 AM 12/23/2013 -0800, Phillip Ponchot wrote:
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.
Probably anathema, certainly 1-2 hours of work if you have a server sandbox, set up a "no-frills" 3.6 Koha and verify that the various "frameworks" are what you need. Restore your mysql dump, and the scripts will convert the db to a standard that future script versions will recognize. (Note; this is from experience, not from an in-depth knowledge of db and conversion script deltas.) Paul
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
--- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>
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
Phillip Ponchot schreef op di 31-12-2013 om 01:22 [-0800]:
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).
If it tries to create a new database, are you sure you're importing into the right place? It really sounds like you aren't. Do your import and then run a few selects to make sure that the data is really there. 'koha-mysql library' and 'SHOW TABLES;' is probably a good place to start. But also do things like 'SELECT count(*) FROM biblio;' to make sure there's actually content there. But first, read the other email I sent, it has more info that may help. The database dump contains a 'USE koha_whatever;' command, naming the database it comes from. If you are trying to import into a database with a different name, you're going to have a bit of trouble unless you're careful. One of the results can be that the data doesn't end up where you expect.
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.
Posting 1.5 hours before the start of New Year's day will not engender fast replies, fyi :) There are people/companies out there that you could pay to do the data conversion for you, but you shouldn't really need to, it's quite possible to do it yourself. Note that if you have another go, use the script(1) shell command to record the whole thing. See 'man script' for more information. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
participants (4)
-
David Nind -
Paul A -
Phillip Ponchot -
Robin Sheat