title: Replication not updating all tables
body: <ul>
  <li>Master db MySQL db Server 2012 </li>
  <li>Slave db MySQL Win7 XAMPP</li>
  <li>DB size 500MB</li>
  <li>Table count 42</li>
  </ul>
  
  <p>I have setup the replication successfully however it stopped last week and my slave was showing the error <code>Slave_SQL_Running No</code>. I realised that it was looking at an incorrect log file (00004 whereas it should have been 00006).</p>
  
  <p>I have since sorted this by;</p>
  
  <p>At the MASTER;</p>
  
  <pre><code>SHOW MASTER STATUS;
  Copied the values of MASTER_LOG_FILE and MASTER_LOG_POS.
  </code></pre>
  
  <p>At the SLAVE;</p>
  
  <pre><code>STOP SLAVE;
  RESET SLAVE;
  CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000001', MASTER_LOG_POS=98; (&lt;- example values)
  START SLAVE;
  SHOW SLAVE STATUS \G;
  </code></pre>
  
  <p>On my master I tested the replication by editing the table <code>members</code> - I edited one of the row values (from <code>85</code> to <code>86</code> - this successfully replicated in my slave). However I notice that on my master <code>members</code> table there are 70652 members but on my slave there are only 70056. </p>
  
  <p>I added two new members to my master members table and the total increases by 2 on both tables. However there still seems to be that 600 missing?</p>
  
  <p>What could be the problem? Replication seems to be working but totals aren't. New members are added to the members table each day, but the aren't being added to my slave members table. </p>
  
  <p>The results of my slave status table (from phpmyadmin) are;</p>
  
  <pre><code>Slave_IO_State  Waiting for master to send event
  Master_Host xxx.xxx.xxx.xxx
  Master_User repl
  Master_Port 3306
  Connect_Retry   60
  Master_Log_File mysql-bin.000006
  Read_Master_Log_Pos 787956776
  Relay_Log_File  mysql-relay-bin.000004
  Relay_Log_Pos   624412
  Relay_Master_Log_File   mysql-bin.000006
  Slave_IO_Running    Yes
  Slave_SQL_Running   Yes
  Replicate_Do_DB 
  Replicate_Ignore_DB 
  Replicate_Do_Table  
  Replicate_Ignore_Table  
  Replicate_Wild_Do_Table 
  Replicate_Wild_Ignore_Table 
  Last_Errno  0
  Last_Error  
  Skip_Counter    0
  Exec_Master_Log_Pos 787956776
  Relay_Log_Space 788197
  Until_Condition None
  Until_Log_File  
  Until_Log_Pos   0
  Master_SSL_Allowed  No
  Master_SSL_CA_File  
  Master_SSL_CA_Path  
  Master_SSL_Cert 
  Master_SSL_Cipher   
  Master_SSL_Key  
  Seconds_Behind_Master   0
  </code></pre>
  
  <p>Is there something else that I could check or test?</p>