[Koha] Migrating old data to a new installation of Koha

["Thommy M. Malmström"]

Thommy M. Malmström wrote:
> benson Mugambi wrote:
>> Hi folks,
>> I have done a clean install of Koha 3.0 on Ubuntu 8.0 and i need to 
>> migrate my old data from Koha 2.2.9 but am facing some problems. THe old 
>> database has about 74 tables, the new one has 125. When i import data 
>> using phpmyadmin, the system terminates at the first table due to 
>> primary key differences in the both structures. Can someone advice me 
>> the best way i should migrate this data to maintain integrity of the 
>> MARC structure flawlessly.
> 
> 1- mysqldump your 2.2.9 DB
> 2- drop your empty 3.0 DB
> 3- mysql -ulogin -ppass koha3 <your_229_dump.sql
> 4- follow the steps at 22_to_30 to upgrade your DB correctly.
> 
> 
> I asked the same earlier and got the above answer. However I did not succeed as I 
> don't understand in which order the perl scripts in part 4 is to be run. But I 
> have to do it soon as my librarian keeps asking when we will upgrade... :-(
> Must set up a couple of VirtualBox instances and play around I think.
> 
> The scripts in koha-3.00.00/misc/migration_tools/22_to_30
> 
> -rw-r--r-- 1 thommym service  347 2008-08-08 14:56 biblio_framework.sql
> -rwxr-xr-x 1 thommym service  704 2008-08-08 14:56 convert_to_utf8.pl
> -rwxr-xr-x 1 thommym service 1846 2008-08-08 14:56 export_Authorities.pl
> -rwxr-xr-x 1 thommym service 1418 2008-08-08 14:56 export_Authorities_xml.pl
> -rwxr-xr-x 1 thommym service 2322 2008-08-08 14:56 missing090field.pl
> -rwxr-xr-x 1 thommym service 4418 2008-08-08 14:56 move_marc_to_authheader.pl
> -rwxr-xr-x 1 thommym service 5822 2008-08-08 14:56 move_marc_to_biblioitems.pl
> -rw-r--r-- 1 thommym service 1646 2008-08-08 14:56 phrase_log.sql
> -rwxr-xr-x 1 thommym service 1284 2008-08-08 14:56 rebuild_leader.pl
> -rwxr-xr-x 1 thommym service 1795 2008-08-08 14:56 rebuild_unimarc_100.pl
> 
> 
> So, $10,000 question is: In which order do I run them?

The answer is probably here...

http://wiki.koha.org/doku.php?id=22_to_30