If replication stops and the slave status shows:<\/p>\n
Last_Errno: 1580 Last_Error: Error ‘You cannot ‘ALTER’ a log table if logging is enabled’ on query. Default database: ‘mysql’.<\/p>\n
You need to skip over a bad query as follows:<\/p>\n
mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;<\/p>\n
This tells the slave to skip one query (which is the invalid one that caused the replication to stop). If you’d like to skip two queries, you’d use SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 2; instead and so on.<\/p>\n
That’s it already. Now we can start the slave again…<\/p>\n
mysql> START SLAVE;<\/p>\n
check if replication is working again with the SHOW SLAVE STATUS \\G;<\/p>\n","protected":false},"excerpt":{"rendered":"
If replication stops and the slave status shows: Last_Errno: 1580 Last_Error: Error ‘You cannot ‘ALTER’ a log table if logging is enabled’ on query. Default database: ‘mysql’. You need to skip over a bad query as follows: mysql> SET GLOBAL … Continue reading