[Koha] Importing Koha Database to a new install

[Phillip Ponchot]

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 at live.com
> To: david.nind at gmail.com; koha at 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 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
>  		 	   		  
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha