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