mysql schema script reports errors

Project:OpenMIC - Moving Image Collections Bibliographic Utility
Version:1.0-beta
Component:Documentation
Category:bug report
Priority:normal
Assigned:cmmills
Status:closed
Description

after creating a database with utf8 encoding:
CREATE DATABASE openmic_pre20 character set utf8;

and running the schema script as so:
mysql -u openmic --force -p openmic_pre20 < dwms_schema_cv_mysql.sql

we received the following errors:

ERROR 1062 (23000) at line 2482: Duplicate entry 'Local' for key 1
ERROR 1062 (23000) at line 2490: Duplicate entry 'MIC-ancillary' for key 1
ERROR 1062 (23000) at line 2494: Duplicate entry 'MIGFG-form' for key 1
ERROR 1062 (23000) at line 2495: Duplicate entry 'MIGFG-genre' for key 1
ERROR 1062 (23000) at line 2525: Duplicate entry 'Term source' for key 1
ERROR 1062 (23000) at line 2537: Duplicate entry 'aat' for key 1
ERROR 1062 (23000) at line 2544: Duplicate entry 'ka' for key 1
ERROR 1062 (23000) at line 2547: Duplicate entry 'lcsh' for key 1
ERROR 1062 (23000) at line 2550: Duplicate entry 'local' for key 1
ERROR 1062 (23000) at line 2551: Duplicate entry 'marcRelator' for key 1
ERROR 1062 (23000) at line 2552: Duplicate entry 'marcrelator' for key 1
ERROR 1062 (23000) at line 2554: Duplicate entry 'mic' for key 1
ERROR 1062 (23000) at line 2558: Duplicate entry 'rulib' for key 1
ERROR 1062 (23000) at line 2560: Duplicate entry 'term source' for key 1
ERROR 1062 (23000) at line 2561: Duplicate entry 'test' for key 1

Comments

#1

Component:Miscellaneous» Documentation
Assigned to:Anonymous» cmmills
Status:active» fixed

Yang Yu stated:

You have created a database with case-insensitive collation, which is where this error messages are coming from. Use following command to create database (remember to change db name):

create database openmic character set utf8 collate utf8_bin;

I'll update the README file for installation.

#2

Version:<none>» 1.0-beta
Status:fixed» closed

Back to top