MSQL: Difference between revisions

From CLONWiki
Jump to navigation Jump to search
No edit summary
(No difference)

Revision as of 12:08, 11 March 2008

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 ???