[Koha] Koha - copying frameworks ongong

[Tomas Cohen Arazi]

On Mon, Apr 25, 2011 at 1:27 PM, Linda Culberson
<lculber at 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+