We have a large database with 90 tables .
we need to get daily backups to our office pc.
We need to create a cron system to backup one table at a time ( because of the size of some tables is millions of records) and compress it to it's fullest so a home pc can login to our server and download files and get backups on a daily matter.
also a cron will need to remove previuos backup file when new one is created so a large list of backup files is not created on server.
Need this asap!!!!!