Still don't know the root cause.. but here is how to fix it:
STOP SLAVE;
SET GLOBAL slow_query_log = 'OFF'; SET GLOBAL sql_log_bin = 0;
START SLAVE;
Sunday, June 9, 2013
Problem with MySql Replication: Last_Errno: 1580 Last_Error: Error 'You cannot 'ALTER' a log table if logging is enabled' on query. Default database: 'mysql'.q
Still don't know the root cause.. but here is how to fix it:
STOP SLAVE;
SET GLOBAL slow_query_log = 'OFF'; SET GLOBAL sql_log_bin = 0;
START SLAVE;
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment