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+