Hello,
Can anyone tell me what advantages there are in keeping dates and times in a
MySQL DateTime field, as opposed to storing its string equivalent in a Varchar
field ?
Regards,
Danny
Dear All,
Here's our setup :
Master : MySQL v4.0.16-max-log
Slave : MySQL v4.1.10a-max-log
Everytime I do an ALTER TABLE on the master server, I get the following
error message on the slave server.
050723 1:51:26 [ERROR] Slave: Error 'Duplicate column name
'TimefileDate'' on query.
Dear All,
Am planning on making MySQL write its data files to disk1 and log files
to disk2.
My questions are :
1. I know I can put the connections, slow, query, and InnoDB logs on
disk2.
Is it also possible (and advisable) to put the binary logs with them
?
2. If disk2 is slower