<p>I'm working on developing a regular dump of our database. I'm using <a href="http://davidwalsh.name/backup-mysql-database-php" rel="nofollow noreferrer">this script</a> to create the backup and then feeding it through a regular cron job.  In the end we end up with a text file as well as an email archive of everything.</p>

<p>The problem we've encountered is the size of two of our tables.  They each have 60k fields and grow daily. I'm thinking incremental backup are the best solution for backup, but if it ever came to restoring it... It will be a huge project.</p>

<p>My question is a two parter: </p>

<p>a) Is there a more straight forward way to backup huge tables on a daily basis and, if not, </p>

<p>b) Is there an easy way to restore a backup from daily/weekly incremental backups?</p>

<p>Thanks!</p>

You can use a crob job to execute mysqldump to dump the tables down that you wish to backup.  Then just use a differential backup on that file for the daily backup and do a full backup once a week.  The backup's heavy lifting should be done by your backup engine of choice.
Restoring a DB is never fun, so regardless it will be a big project.
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
Let me know if this works for you.