[Koha] Importing Koha Database to a new install

[Paul A]

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 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

---
Maritime heritage and history, preservation and conservation,
research and education through the written word and the arts.
<http://NavalMarineArchive.com> and <http://UltraMarine.ca>