title: mysql partial restore from backup
body: <p>Due to a server crash I need to restore some rows, created within a certain period of time, from the backup (located on my local machine) onto the live db on server. </p>
  
  <p>To select the rows in question I plan to do something like this from the backupdatabase:</p>
  
  <pre><code>SELECT *
  FROM access AS t1
  WHERE AccessId IN (
  SELECT AccessId FROM access_completed AS t1
  WHERE (TIMEDIFF(CCompleteDateTime, "2011-01-24 02:00:00") &lt; 23 AND TIMEDIFF(CCompleteDateTime, "2011-01-24 02:00:00") &gt; 0)
  )
  </code></pre>
  
  <p>How do I insert the resulting rows into the live db?</p>