Differences

This shows you the differences between two versions of the page.

--- mysql:replication [2008/06/08 12:38]
193.164.137.52 + how to fix mysql replication
+++ mysql:replication [2009/05/25 00:35]
@@ Line 1: / Line 1: @@
-====== MySQL replication ======
-   * [[http://www.howtoforge.com/how-to-repair-mysql-replication|How to repait MySQL replication]]
-   mysql> SHOW SLAVE STATUS \G
-   ...
-   Replicate_Wild_Ignore_Table:
-                    Last_Errno: 1146
-                    Last_Error: Error 'Table 'mydb.taggregate_temp_1212047760' doesn't exist' on query. Default database: 'mydb'.
-    Query: 'UPDATE thread AS thread,taggregate_temp_1212047760 AS aggregate
-           SET thread.views = thread.views + aggregate.views
-           WHERE thread.threadid = aggregate.threadid'
-   ...
-   mysql> STOP SLAVE;
-   mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;
-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.
-   mysql> START SLAVE;
-   mysql> SHOW SLAVE STATUS \G
-===== Master + Slave =====
-===== Master Master  =====
-see [[http://www.howtoforge.com/mysql_master_master_replication|this]]