title: mySQL daily backup from one table to another
body: <p>If I have 2 tables with the same definition, how would I backup data from it daily? Can I use mySQL Administrator to perform something like this</p>
  
  <ul>
  <li>At 12:00am everyday, copy all the rows from main_table to backup_table</li>
  <li>It will be preferable if it is incremental backup as some changes will be made to the reccords in backup_table and I don't want a new backup to wipe out those changes.</li>
  </ul>
  
  <p>Thanks</p>