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 lculber@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
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 lculber@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
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 lculber@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
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 <lculber@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 lculber@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) jcamins@cpbibliography.com (web) http://www.cpbibliography.com/
On Mon, Apr 25, 2011 at 1:27 PM, Linda Culberson <lculber@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+
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_framew... Best regards, Magnus Enger libriotech.no On 25 April 2011 18:27, Linda Culberson <lculber@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 lculber@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
participants (4)
-
Jared Camins-Esakov -
Linda Culberson -
Magnus Enger -
Tomas Cohen Arazi