MSQL - Revision history

129.57.121.200 at 18:11, 13 June 2008

2008-06-13T18:11:08Z

← Older revision		Revision as of 14:11, 13 June 2008
Line 8:		Line 8:
	mysql -h clondb1 -u clasrun daq_clasdev < clasdev.sql		mysql -h clondb1 -u clasrun daq_clasdev < clasdev.sql

	NOTE: ~~database~~ 'daq_clasrun' must be created and have appropriate privileges.		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()		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).

129.57.121.200 at 16:27, 11 June 2008

2008-06-11T16:27:46Z

← Older revision		Revision as of 12:27, 11 June 2008
Line 4:		Line 4:

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

	NOTE: database 'daq_clasrun' must be created and have appropriate privileges.		NOTE: database 'daq_clasrun' must be created and have appropriate privileges.

129.57.121.200 at 16:19, 11 June 2008

2008-06-11T16:19:51Z

← Older revision		Revision as of 12:19, 11 June 2008
Line 3:		Line 3:
	command was used (in release 2.1 only !!!):		command was used (in release 2.1 only !!!):

	msqldump clasrun > ~~msqldump~~.sql		msqldump clasrun > clasrun.sql
	mysql -h clondb1 -u clasrun daq_clasrun < ~~msqldump~~.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;		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).

129.57.121.200 at 16:14, 11 June 2008

2008-06-11T16:14:17Z

← Older revision		Revision as of 12:14, 11 June 2008
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 dump mSQL following		There is a plan to move to mySQL. To dump mSQL following
	command was used:		command was used (in release 2.1 only !!!):

	msqldump clasrun > msqldump.sql		msqldump clasrun > msqldump.sql

129.57.121.200 at 16:38, 11 March 2008

2008-03-11T16:38:42Z

← Older revision		Revision as of 12:38, 11 March 2008
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 ~~dimp~~ mSQL following		There is a plan to move to mySQL. To dump mSQL following
	command ~~can be~~ used:		command was used:

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

	Observed problem: 'BONUS' and 'bonus' recognized by mySQL as identical key;		Observed problem: 'BONUS' and 'bonus' recognized by mySQL as identical key;
	~~probably~~ 'msqldump' ~~must be~~ modified to use VARCHAR() BINARY instead of CHAR().		To fix it 'msqldump' was modified to use VARCHAR() BINARY instead of CHAR()
	~~Also, index is not defined ???~~		for primary keys. Some other changes were applied as well (see code).

129.57.121.200 at 16:08, 11 March 2008

2008-03-11T16:08:49Z

New page

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