Migrating old data to a new installation of Koha
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. Thanks Benson Mugambi SHAREDOC What comes out of you when you are squeezed is what is inside you. - Wayne Dyer
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?
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
participants (2)
-
"Thommy M. Malmström" -
benson Mugambi