Upgrading from 3.02.02 (tarball install) to latest (package install)
Hi everyone, I'm managing an older, running 3.02.02 install that was done via tarball install and I'd like to both move to the package install and upgrade to the latest 3.14.x version. I've tried following the instructions at http://wiki.koha-community.org/wiki/Moving_an_installation_from_a_regular_in stall_to_the_Debian_packages to migrate from tarball to package installs but find that my DB schema in MySQL doesn't seem to follow the current naming "standards" and is named 'kohadb' instead of 'koha_<sitename>'. So, when I run the 'koha-create' on the new system the DB schema isn't named the same as the one contained in the MySQL backup that is restored in the next step and I therefore don't have any data in the "new" version. Anyone have any suggestions on how to resolve this properly? I also then received errors during the "sudo koha-upgrade-schema <instancename>" step, but I'm pretty sure that was because of the issue with the schema names. Sound familiar to anyone (has anyone upgraded from 3.02.02 directly to some fairly recent version or have most people done "incremental" upgrades along the way so they didn't have this issue? Thanks for any help anyone can offer! Steve
On do, 2014-01-30 at 17:07 -0500, Steven Nickerson wrote:
So, when I run the 'koha-create' on the new system the DB schema isn't named the same as the one contained in the MySQL backup that is restored in the next step and I therefore don't have any data in the "new" version. Anyone have any suggestions on how to resolve this properly?
Oh, easy. Where the instructions say: $ sudo koha-mysql <instancename> < mybackup.sql instead do: $ sudo koha-mysql <instancename> ... mysql> \. mybackup.sql This will mean the whole thing doesn't run in a transaction, and the CREATE DATABASE and USE lines will fail, but this won't abort the whole import like it does the first way. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
participants (2)
-
Robin Sheat -
Steven Nickerson