Moving to a newer server and OS
We'd like to upgrade to Koha 3.0, but put it on a new server. Our current OS is Debian Sarge. The new server will need to run Etch because Sarge won't install on the new hardware. This also means we'll be switching from MySQL version 4 to 5. Is it possible to do a mysqldump on the old server and load the data on the new server, then install Koha 3 and do the updates? Is there anything I need to do to the database for the MySQL upgrade before I start the Koha updates? -- Tim McMahon Technical Services West Liberty Public Library 400 N. Spencer St. West Liberty, IA 52776 Phone: 319-627-2084 Fax: 319-627-2135 tmcmahon@wlpl.org http://www.wlpl.org
Hey Tim, On Fri, Apr 4, 2008 at 4:15 PM, Tim McMahon - West Liberty Public Library <tmcmahon@wlpl.org> wrote:
We'd like to upgrade to Koha 3.0, but put it on a new server. Our current OS is Debian Sarge. The new server will need to run Etch because Sarge won't install on the new hardware. This also means we'll be switching from MySQL version 4 to 5. Is it possible to do a mysqldump on the old server and load the data on the new server, then install Koha 3 and do the updates? Is there anything I need to do to the database for the MySQL upgrade before I start the Koha updates? Before doing the update, I'd recommend getting Koha 3 up and running on your Etch box, playing around with it, there's a nice amount of sample data, and you can easily enough import some sample bib data, to get your feet wet.
Koha 3 requires mysql version 5 or greater. You can do a restore from a mysqldump from an earlier version of mysql to mysql 5. There are some instructions for upgrading from Koha 2 up on the wiki: http://wiki.koha.org/doku.php?id=22_to_30 Note the QANotes here: http://wiki.koha.org/doku.php?id=en:development:qanotes3.0, which explain some of the changes and new conventions (including things like frameworks and statuses). The Zebra-related notes are of particular importance as well, though most of the heavy lifting for that stuff is handled by the installer. As always, be sure to test everything carefully on a test instance before running it on your production database. Let us know how you like 3.0, and if you have any questions. Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE CEO migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf@liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS
Joshua, Is is possible if you simply want to move your books/records (not sure what they are actually called) can you Marc21 export from the Koha v2.x.x and then import via v3.0? I tried this today as I finally got Koha v3.0 up and running, and the Marc21 data staged fine...but when 'completing the import' it got to 8% and then hung...didn't move for 2hrs...so I figured it was *pooft* --Huck Joshua Ferraro wrote:
Hey Tim,
On Fri, Apr 4, 2008 at 4:15 PM, Tim McMahon - West Liberty Public Library <tmcmahon@wlpl.org> wrote:
We'd like to upgrade to Koha 3.0, but put it on a new server. Our current OS is Debian Sarge. The new server will need to run Etch because Sarge won't install on the new hardware. This also means we'll be switching from MySQL version 4 to 5. Is it possible to do a mysqldump on the old server and load the data on the new server, then install Koha 3 and do the updates? Is there anything I need to do to the database for the MySQL upgrade before I start the Koha updates? Before doing the update, I'd recommend getting Koha 3 up and running on your Etch box, playing around with it, there's a nice amount of sample data, and you can easily enough import some sample bib data, to get your feet wet.
Koha 3 requires mysql version 5 or greater. You can do a restore from a mysqldump from an earlier version of mysql to mysql 5. There are some instructions for upgrading from Koha 2 up on the wiki:
http://wiki.koha.org/doku.php?id=22_to_30
Note the QANotes here: http://wiki.koha.org/doku.php?id=en:development:qanotes3.0, which explain some of the changes and new conventions (including things like frameworks and statuses). The Zebra-related notes are of particular importance as well, though most of the heavy lifting for that stuff is handled by the installer.
As always, be sure to test everything carefully on a test instance before running it on your production database.
Let us know how you like 3.0, and if you have any questions.
Cheers,
the small elementary school of 100 kids is easy enough to script patrons in with the patron import CSV file the same time I create accounts at the beginning of the year... We use it at a 250 student high school and 100 student elementary school...love 2.2.9(i think is what we currently are on) but any idea why it would be hanging, after staged it should be golden for completing the import no? about 11,000 items being imported. --Huck Joe Atzberger wrote:
Is is possible if you simply want to move your books/records (not sure what they are actually called) can you Marc21 export from the Koha v2.x.x and then import via v3.0?
Yes, but you might want your policies, settings, and especially your patron data!
--Joe Atzberger LibLime
Hi Huck Make sure you have the nozebra system preference set to off. Are you running the commandline staging/import scripts? Ryan On Fri, Apr 4, 2008 at 7:51 PM, Huck <dhuckaby@paasda.org> wrote:
the small elementary school of 100 kids is easy enough to script patrons in with the patron import CSV file the same time I create accounts at the beginning of the year...
We use it at a 250 student high school and 100 student elementary school...love 2.2.9(i think is what we currently are on)
but any idea why it would be hanging, after staged it should be golden for completing the import no? about 11,000 items being imported.
--Huck
Joe Atzberger wrote:
Is is possible if you simply want to move your books/records (not
sure
what they are actually called) can you Marc21 export from the Koha v2.x.x and then import via v3.0?
Yes, but you might want your policies, settings, and especially your patron data!
--Joe Atzberger LibLime
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Ryan Higgins LibLime * Open-Source Solutions for Libraries Featuring KohaZOOM ILS 888-564-2457 x704
On Fri, Apr 4, 2008 at 7:25 PM, Huck <dhuckaby@paasda.org> wrote:
Joshua,
Is is possible if you simply want to move your books/records (not sure what they are actually called) can you Marc21 export from the Koha v2.x.x and then import via v3.0? Sure, you could do that...
I tried this today as I finally got Koha v3.0 up and running, and the Marc21 data staged fine...but when 'completing the import' it got to 8% and then hung...didn't move for 2hrs...so I figured it was *pooft* I bet it finished ... check under Manage Staged MARC Records in tools. It's done as a background process, and sometimes the status doesn't update.
Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE CEO migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf@liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS
participants (5)
-
Huck -
Joe Atzberger -
Joshua Ferraro -
Ryan Higgins -
Tim McMahon - West Liberty Public Library