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