Hi

when I execute

mysql> show slave status\G

I see this:

...
                 Last_Errno: 1175
Last_Error: Error 'You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column' on query. Default database: 'xxx'. Query: 'delete from xxx'
...

However, safe-updates is not configured in my.cnf and I also think this is a CLIENT SESSION variable.

How can I disable safe-updates for the slave-thread (if it should be configured).

What else could be the reason?

Regards
Dominik

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to