MSQL: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 3: | Line 3: | ||
command was used (in release 2.1 only !!!): | command was used (in release 2.1 only !!!): | ||
msqldump clasrun > | msqldump clasrun > clasrun.sql | ||
mysql -h clondb1 -u clasrun daq_clasrun < | mysql -h clondb1 -u clasrun daq_clasrun < clasrun.sql | ||
NOTE: database 'daq_clasrun' must be created and have appropriate privileges. | |||
Observed problem: 'BONUS' and 'bonus' recognized by mySQL as identical key; | Observed problem: 'BONUS' and 'bonus' recognized by mySQL as identical key; | ||
To fix it 'msqldump' was modified to use VARCHAR() BINARY instead of CHAR() | To fix it 'msqldump' was modified to use VARCHAR() BINARY instead of CHAR() | ||
for primary keys. Some other changes were applied as well (see code). | for primary keys. Some other changes were applied as well (see code). | ||
Revision as of 11:19, 11 June 2008
mSQL database is used by CODA to store configurations. There is a plan to move to mySQL. To dump mSQL following command was used (in release 2.1 only !!!):
msqldump clasrun > clasrun.sql mysql -h clondb1 -u clasrun daq_clasrun < clasrun.sql
NOTE: database 'daq_clasrun' must be created and have appropriate privileges.
Observed problem: 'BONUS' and 'bonus' recognized by mySQL as identical key; To fix it 'msqldump' was modified to use VARCHAR() BINARY instead of CHAR() for primary keys. Some other changes were applied as well (see code).