title: Backup only yesterday's data from one table
body: <p>I tried to research this but could not find anything, so I'm back to asking the collective.</p>
  
  <p>In a fairly busy MySQL DB I have an access_log table which gets about 10 million records a day.  The goal is to get yesterday's records and move them to a different DB on a different server.  Is there a way to hot backup only yesterday's data from just that table?</p>
  
  <p>Thank you for your input,
  Kate</p>