MSQL: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
mSQL database is used by CODA to store configurations. | mSQL database is used by CODA to store configurations. | ||
There is a plan to move to mySQL. To | There is a plan to move to mySQL. To dump mSQL following | ||
command | command was used (in release 2.1 only !!!): | ||
msqldump | msqldump clasrun > clasrun.sql | ||
mysql -h clondb1 -u clasrun daq_clasrun < | msqldump clasdev > clasdev.sql | ||
mysql -h clondb1 -u clasrun daq_clasrun < clasrun.sql | |||
mysql -h clondb1 -u clasrun daq_clasdev < clasdev.sql | |||
NOTE: databases 'daq_clasrun' and 'daq_clasdev' must be created and user 'clasrun' must have an appropriate privileges to access those databases (normally 'ALL_PRIVILEGES'). It can be useful to re-create entire database before filling it up, for example: | |||
mysql -h clondb1 -u clasrun | |||
mysql> drop database daq_clasrun; | |||
mysql> create database daq_clasrun; | |||
mysql> exit | |||
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() | |||
for primary keys. Some other changes were applied as well (see code). | |||
Latest revision as of 13:11, 13 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 msqldump clasdev > clasdev.sql mysql -h clondb1 -u clasrun daq_clasrun < clasrun.sql mysql -h clondb1 -u clasrun daq_clasdev < clasdev.sql
NOTE: databases 'daq_clasrun' and 'daq_clasdev' must be created and user 'clasrun' must have an appropriate privileges to access those databases (normally 'ALL_PRIVILEGES'). It can be useful to re-create entire database before filling it up, for example:
mysql -h clondb1 -u clasrun mysql> drop database daq_clasrun; mysql> create database daq_clasrun; mysql> exit
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).