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

["Thommy M. Malmström"]

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?