mysql replication & mismatched count of records in master/slave db

2002-11-25 Thread Kath O'Donnell
Hi, I'm new to the list (& mysql) and not sure if there is an archive I can search so apologies if this has been mentioned earlier. I was hoping someone might be able to shed some light on a problem I am having: I'm supporting a mysql 3.23.49 database with one master db (type=BerkleyDB) and two s

system date / curdate()

2002-12-01 Thread Kath O'Donnell
hi, which date does mysql use to calculate CURDATE()? I have a master database telling me via the select CURDATE(); command that today is : mysql> select CURDATE(); ++ | CURDATE() | ++ | 2002-12-01 | ++ 1 row in set (0.00 sec) even though the linux date is set