R: what about slave_skip_errors variables

2005-12-28 Thread AESYS S.p.A. [Enzo Arlati]
-Messaggio originale- Da: Atle Veka [mailto:[EMAIL PROTECTED] Inviato: mercoledi 28 dicembre 2005 20.47 A: AESYS S.p.A. [Enzo Arlati] Cc: mysql@lists.mysql.com Oggetto: Re: what about slave_skip_errors variables Are you saying that "from time to time it happens that data gets inserted

Re: what about slave_skip_errors variables

2005-12-28 Thread Atle Veka
Are you saying that "from time to time it happens that data gets inserted directly to the slave"? In other words, they are NOT inserted into the master. Have you looked into using this mysqld option, which prevents accidental slave updates? --read-only Make all tables readonly, with the

Re: what about slave_skip_errors variables

2005-12-27 Thread Gleb Paharenko
Hello. > 'pmv_manager_log_bin.69' at position 743 Find out with mysqlbinlog utility what statement causes the error. Then execute it manually on the slave to get an error code which it produces. What version of MySQL are you using? May be with the fresher one you will get more informat

what about slave_skip_errors variables

2005-12-27 Thread AESYS S.p.A. [Enzo Arlati]
Hi, I got some mysql server connectet with the replica enabled and from time to time it appen that the replicated data are still be inserted in the slave, so the replication server stop working due the duplicate entry error. For my purpose there is no matter to ignore these errors so I try to use