I have installed a koha 3.0.1 that can handle utf8 and it looks all OK. Then I have a dump from a 2.2.9 (in utf8). My idea is to load the 2.2.9 dump as a new database, say testkoha, in MySQL and copy to koha version 3 with some INSERT SELECT commands as shown below. My question is, which tables do I need to copy? I have recognized biblio, biblioitems, items, but there are probably more. Is this approach good or is there anything easier I can do??? I've not tried the 22_to_30 way, but I don't think that is applicable in my scenario. Example of my idea... mysql> INSERT INTO koha.biblio (biblionumber, frameworkcode, author, title, unititle, notes, serial, seriestitle, copyrightdate, timestamp, datecreated, abstract) SELECT biblionumber, frameworkcode, author, title, unititle, notes, serial, seriestitle, copyrightdate, timestamp, datecreated, abstract FROM kohatest.biblio;
On 2009/02/23, at 8:39 AM, Thommy M. Malmström wrote:
I have installed a koha 3.0.1 that can handle utf8 and it looks all OK.
I've not tried the 22_to_30 way, but I don't think that is applicable in my scenario.
Thommy, i think 22_to_30 will be the only way for you http://wiki.koha.org/doku.php?id=22_to_30&s=update there are many db structure changes between your versions that are handled by this process
Mason James wrote:
On 2009/02/23, at 8:39 AM, Thommy M. Malmström wrote:
I have installed a koha 3.0.1 that can handle utf8 and it looks all OK.
I've not tried the 22_to_30 way, but I don't think that is applicable in my scenario.
Thommy, i think 22_to_30 will be the only way for you http://wiki.koha.org/doku.php?id=22_to_30&s=update
there are many db structure changes between your versions that are handled by this process
Only thing is that I can't figure out how to run it. The 22_to_30 page is a mess IMHO and does not explain how to run different parts and what each step do. I'm sure that I just can't run all of it 'cause it will ruin the setup that I have. I'll rather do the cataloging again for all our items (just a couple of thousand) than letting some script mess with the unicode configs that I've struggled hard with.
On 2009/02/24, at 7:09 AM, Thommy M. Malmström wrote:
Mason James wrote:
On 2009/02/23, at 8:39 AM, Thommy M. Malmström wrote:
I have installed a koha 3.0.1 that can handle utf8 and it looks all OK.
I've not tried the 22_to_30 way, but I don't think that is applicable in my scenario.
Thommy, i think 22_to_30 will be the only way for you http://wiki.koha.org/doku.php?id=22_to_30&s=update
there are many db structure changes between your versions that are handled by this process
Only thing is that I can't figure out how to run it. The 22_to_30 page is a mess IMHO and does not explain how to run different parts and what each step do.
well, it worked OK for me on my first 2.2 -> 3.0 upgrade few weeks ago.
I'm sure that I just can't run all of it 'cause it will ruin the setup that I have.
set up another copy of your koha2.2 to do the actual upgrade on ;) and make a backup before, too ;p
participants (2)
-
"Thommy M. Malmström" -
Mason James