MSQL

From CLONWiki
Revision as of 11:08, 11 March 2008 by 129.57.121.200 (talk)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

mSQL database is used by CODA to store configurations. There is a plan to move to mySQL. To dimp mSQL following command can be used:

msqldump -c clasrun > msqldump.sql
mysql -h clondb1 -u clasrun daq_clasrun < msqldump.sql

Observed problem: 'BONUS' and 'bonus' recognized by mySQL as identical key; probably 'msqldump' must be modified to use VARCHAR() BINARY instead of CHAR(). Also, index is not defined ???