Restoring the default Marc Framework
Hi all I altered the default marc Framework. I understand that it's not a good idea. How can I restore the original Default MARC Framework (in my case the one at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql Does simply running mysql -u koha_<instancename> -p koha_<instancename> < marc21_framework_DEFAULT.sql do the job? Or is this dangerous? cu Beda
I altered the default marc Framework. I understand that it's not a good idea.
How can I restore the original Default MARC Framework (in my case the one at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql
First, do a backup.
As you talk about instances, I presume you are using packages. Frameworks are stored in the database, so first detect which database you need to change, i.e. which instance. Look in /etc/koha/sites/"instance"/koha-conf.xml, near the end you will find name of database, dbuser and dbpassword Next, remove default framework mysql -uuser -ppass db -e "delete from marc_tag_structure where frameworkcode = ''; delete from marc_subfield_structure where frameworkcode = ''" Next, load default framework mysql -uuser -ppass db < /usr/share/koha/intranet/cgi- bin/installer/data/mysql/de-DE/marcflavour/marc21/ mandatory/marc21_framework_DEFAULT.sql Regards, Bernardo
Hi Thank you for your help. It worked with one little exeption: The new default-framework hasn't the correct encoding. For example the word "für" is displayed "für", "Länge" is "Länge" Why? file marc21_framework_DEFAULT.sql shows: UTF-8 Unicode Pascal program text, with very long lines so the file should be o.k. The server runs debian stable, I installed the koha packages, I'm connecting to the server with putty Regards, Beda Am 12.04.2013 19:34, schrieb Bernardo Gonzalez Kriegel:
First, do a backup.
load default framework
mysql -uuser -ppass db < /usr/share/koha/intranet/cgi-bin/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql
Hi Am 13.04.2013 14:07, schrieb Beda Szukics:
It worked with one little exeption: The new default-framework hasn't the correct encoding.
For example the word "für" is displayed "für", "Länge" is "Länge"
mysql -uuser -ppass db < /usr/share/koha/intranet/cgi-bin/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql
adding --default-character-set=utf8 after mysql did the job. Thank you
It worked with one little exeption: The new default-framework hasn't the correct encoding. adding --default-character-set=utf8 after mysql did the job.
Ah, I don't know if pacakges are managing mysql encoding properly.
You must set up your MySQL server so it uses utf8 always. (http://wiki.koha-community.org/wiki/Encoding_and_Character_Sets_in_Koha) I also set encoding in the client section, [client] default-character-set=utf8 Glad that you have your framework again. Regards, Bernardo Thank you
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
Beda Szukics -
Bernardo Gonzalez Kriegel