[Koha] Importing Koha Database to a new install

[Phillip Ponchot]

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 at gmail.com
To: pponchot at live.com; koha at 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_Instructions
http://wiki.koha-community.org/wiki/Commands_provided_by_the_Debian_packages#koha-upgrade-to-3.4




On 23 December 2013 09:03, Phillip Ponchot <pponchot at 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 at gmail.com

To: pponchot at live.com
CC: koha at 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 at 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