Re: [Koha] Koha - copying frameworks ongong
Sorry, that doesn't help because it is a different version. It would work from 3.4 to 3.4 but not from 3.2 to 3.4. So I still need help on how to get from 3.2. to 3.4. Thanks. On 4/25/2011 11:04 AM, Linda Culberson wrote: Never mind, I just found Nicole's video! On 4/25/2011 10:59 AM, Linda Culberson wrote: All, We have two instances of Koha. I finally found all of my errors my frameworks in one instance (it is in 3.2) and now want to copy those corrected frameworks over to my second instance which we just upgraded to 3.4. How is the easiest way to do that? Dumping the whole database seems overkill, but I'm not sure what tables are involved besides biblio_framework and marc_subfield_structure. Is there a relatively simple way of doing this? Thanks! -- Linda Culberson lcul...@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha - copying frameworks ongong
Linda, I'd suggest dumping biblio_framework, marc_subfield_structure, and marc_tag_structure and then just reloading them in the other system. Regards, Jared On Mon, Apr 25, 2011 at 12:27 PM, Linda Culberson lcul...@mdah.state.ms.uswrote: Sorry, that doesn't help because it is a different version. It would work from 3.4 to 3.4 but not from 3.2 to 3.4. So I still need help on how to get from 3.2. to 3.4. Thanks. On 4/25/2011 11:04 AM, Linda Culberson wrote: Never mind, I just found Nicole's video! On 4/25/2011 10:59 AM, Linda Culberson wrote: All, We have two instances of Koha. I finally found all of my errors my frameworks in one instance (it is in 3.2) and now want to copy those corrected frameworks over to my second instance which we just upgraded to 3.4. How is the easiest way to do that? Dumping the whole database seems overkill, but I'm not sure what tables are involved besides biblio_framework and marc_subfield_structure. Is there a relatively simple way of doing this? Thanks! -- Linda Culberson lcul...@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha -- Jared Camins-Esakov Freelance bibliographer, C P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcam...@cpbibliography.com (web) http://www.cpbibliography.com/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha - copying frameworks ongong
On Mon, Apr 25, 2011 at 1:27 PM, Linda Culberson lcul...@mdah.state.ms.us wrote: Sorry, that doesn't help because it is a different version. It would work from 3.4 to 3.4 but not from 3.2 to 3.4. So I still need help on how to get from 3.2. to 3.4. Thanks. On 4/25/2011 11:04 AM, Linda Culberson wrote: Never mind, I just found Nicole's video! On 4/25/2011 10:59 AM, Linda Culberson wrote: All, We have two instances of Koha. I finally found all of my errors my frameworks in one instance (it is in 3.2) and now want to copy those corrected frameworks over to my second instance which we just upgraded to 3.4. How is the easiest way to do that? Dumping the whole database seems overkill, but I'm not sure what tables are involved besides biblio_framework and marc_subfield_structure. Is there a relatively simple way of doing this? Thanks! Try creating a shell script named dump_framework.sh with this content (that between code/code): code #!/bin/bash # Informacion de nuestra instalacion DBNAME=YOURDB DBUSER=YOURDBUSER DBPASS=YOURDBUSERPASS # Tablesstoring the frameworks TABLES=marc_tag_structure marc_subfield_structure biblio_framework # Commands MYSQLDUMP=/usr/bin/mysqldump MYSQLDUMPOPTS=--no-create-info FRAMEWORKNAME=$1 for TABLE in $TABLES do $MYSQLDUMP $MYSQLDUMPOPTS -u$DBUSER -p$DBPASS $DBNAME $TABLE --where=frameworkcode='$FRAMEWORKNAME' $TABLE-$FRAMEWORKNAME.sql done /code Change its permissions : # chmod u+x dump_framework.sh Then you can run it like this: # ./dump_framework.sh BKS to dump the framework identified by BKS (code). You'll end up with three files that can be inserted in your other DB. Regards To+ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha - copying frameworks ongong
Hi! There is a recepie for getting one specific MARC framework out of the database here: http://wiki.koha-community.org/wiki/Mysqldump_Library#A_specific_MARC_framework Best regards, Magnus Enger libriotech.no On 25 April 2011 18:27, Linda Culberson lcul...@mdah.state.ms.us wrote: Sorry, that doesn't help because it is a different version. It would work from 3.4 to 3.4 but not from 3.2 to 3.4. So I still need help on how to get from 3.2. to 3.4. Thanks. On 4/25/2011 11:04 AM, Linda Culberson wrote: Never mind, I just found Nicole's video! On 4/25/2011 10:59 AM, Linda Culberson wrote: All, We have two instances of Koha. I finally found all of my errors my frameworks in one instance (it is in 3.2) and now want to copy those corrected frameworks over to my second instance which we just upgraded to 3.4. How is the easiest way to do that? Dumping the whole database seems overkill, but I'm not sure what tables are involved besides biblio_framework and marc_subfield_structure. Is there a relatively simple way of doing this? Thanks! -- Linda Culberson lcul...@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
