title: I need to restore a database (mysql) every 30 minutes using a cron job
body: <p>I'm new to cron jobs and I need to restore a database (mysql) every 30 minutes. Is there a cron job command that can restore a database from a .sql file that's been gzipped?</p>
  
  <p>Or do I need to create a php script to do this and create a cron job to call this script every thirty minutes?</p>
  
  <p>Also, and this is a separate question but still related to cron jobs, I'm using a cron job to backup a different database once a day, gzip it and put it in a folder above the root. Is there a way to (automatically) delete anything older than a month? Or, at least, keep the most recent 20 backups and delete the rest?</p>
  
  <p>There's not a lot of good tutorial out there on this subject other that random forum posts. Any help is appreciated.</p>