title: How to get lost data to mysql replication slave
body: <p>I'm having MASTER-SLAVE mysql replication setup.</p>
  
  <p>suddenly slave crashed. And MASTER worked without any problem. Now I started the SLAVE again. And working fine. Data sync happening OK. </p>
  
  <p>But the problem is, the data is not there on SLAVE at the time when slave was down. (new tables and rows of some tables).</p>
  
  <p>I also did </p>
  
  <pre><code>CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.xxxxxx', MASTER_LOG_POS=xxxxx
  </code></pre>
  
  <p>with the latest position of master. But lost tables and rows not coming to SLAVE.(row counts are lesser than master on some tables;)</p>
  
  <p>NOTE: Current data syncing is working. But the problem is I can't get lost data.</p>
  
  <p>Is there a way to get those data without restarting master database , without going through the whole process again ?</p>
  
  <p>Thanks  </p>