MSQL: Difference between revisions
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 ???