Re: Replication problem

2005-06-02 Thread Weicheng Pan
) VALUES ( 'lty0105', '8', 2p); I took your suggestion and have sent a report. And thank you very much. With best regards, Weicheng Pan Jun 3, 2005. - Original Message - From: "Gleb Paharenko" <[EMAIL PROTECTED]> To: Sent: Thursday, June 02, 2005

Re: Replication problem

2005-06-01 Thread Weicheng Pan
y logs with mysqlbinlog. See: http://dev.mysql.com/doc/mysql/en/mysqlbinlog.html http://dev.mysql.com/doc/mysql/en/slave-logs.html http://dev.mysql.com/doc/mysql/en/binary-log.html Please, next time include the output of SHOW SLAVE STATUS (executed on the slave) and SHOW MASTER STATUS (executed on th

Replication problem

2005-05-30 Thread Weicheng Pan
Hi all: I have replication problem on my FreeBSD 5.4 AMD64 box. Sometimes replication will stop and throw an error code 1054, but the query is not the original one in the master. A query like UPDATE table_a SET col_a = 'abc' where col_b = 234 the right most character will become a strange chara

Re: Deleting from one table blocks other tables?

2003-01-12 Thread pan
> > > I'm trying to delete 5 million rows... Can you drop the table, then re-create it for further use? Anything besides the 5,000,000 you want to keep? > > > > Do you have to do this often? > > Sort of. I have a process that logs to MySQL, and I want to delete old > log entries. I haven't been

trigger function

2001-07-23 Thread Pan, Weiwen (Weiwen)
Please Help! I can't find trigger functions in the documents. Does MySQL has triggers for preselect, preupdate, and predelete? If do, where can I find them? Thanks, Weiwen