Date storage format

2005-10-25 Thread Sinang, Danny
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

Replication stops on ALTER TABLE ; keep on getting duplicate column names

2005-07-31 Thread Sinang, 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.

Separate disk for logs, DRBD ...

2005-07-17 Thread Sinang, Danny
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