[Koha] Introduction and Database Transfer Question

[Chris Cormack]

Hi Robert, and welcome.

The most likely reason you are getting the installer screen is version
differences between the Kohas. If the new server has a newer kohaversion
number than what is in the .sql the web installer will kick in to upgrade
the db.

That's what I would check.

Chris
On May 15, 2012 7:37 AM, "Robert Williams" <williams at amigos.org> wrote:

> Hi All:
>
> I've been lurking for a while, slowly crawling up the Koha learning curve
> ("climbing the curve" might be a bit overstated :-) ). I'm working with a
> library services company preparing to help some of our member libraries
> test/migrate to Koha. Thanks to contributions here, I've gotten around a
> couple of vexing problems. So, first, thanks to the everyone for sharing
> experiences!
>
> I have question related to transferring a Koha database from one "server"
> to another. I'm using the koha-common Debian packages (3.6.4). I've
> configured a Debian virtual server (32-bit Debian Squeeze) with all the
> Koha requirements. It's all running smoothly. I've imported patron and
> bibliographic data and dome some basic "playing" with the system. All is
> well. To test moving the Koha database to a separate machine, I've created
> a second Koha instance. I have used mysqldump to create a .sql file of the
> complete database contents. Then I've re-populated the second instance's
> database using the mysql utility, logging in as the second instance user.
> When I test access to the second instance, all appears well (except that I
> need to learn to re-index the second instance data with Zebra--on the way
> there). I can login to Koha's staff interface and see the patron and bib
> data.
>
> When I try the "same" procedure, except by transferring the .sql file to a
> separate computer (64-bit Debian Squeeze; otherwise same setup). I
> re-populate the new Koha instance there, and can see all the data using the
> mysql utility (or MySQL Workbench from outside the computer). However, when
> I try to login to Koha's staff interface, I get the initial web installer
> screen instead of a staff login screen. If I reload the instance's base
> Koha database (from a separate/backup .sql file), I can login fine. Try
> re-loading the "real" data from the original .sql file, I get the same web
> installer interface problem.
>
> I've probably missed a piece of knowledge somewhere along the learning
> curve. Hopefully not something obvious. And not something I missed in
> searching the list archives. Is there some 32/64-bit Debian issue (maybe a
> character set/code page discrepancy) inherent in the two different versions
> that might cause the problem? My logical mind says all the database fields
> should be set correctly in either case, so that's all I can think it might
> be. Does anybody working with the Debian packages of koha-common have an
> idea what I might be doing wrong? If I need to be smacked for trying to
> move a file from 32-bit to 64-bit OS, smack gently ;-) .
>
> Thanks!
>
> --Robert
>
> *********************************************
> Robert L. Williams
> Manager, Open Source ILS Services
> Amigos Library Services, Inc.
> 14400 Midway Road
> Dallas, TX 75244-3509
> 800-843-8482, x2870
> 972-340-2870<tel:972-340-2870> (direct)
> 972-991-6061<tel:972-991-6061> (fax)
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>