Monthly Archives: November 2013

MySQL Replication Tools

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

Posted in Linux, MySQL | Comments Off on MySQL Replication Tools