I need a Backup of the data from a MYSQL Table to be created and Emailed on a timed basis.
I have been able to get an entire MYSQL Databse backed up, gzipped and Emailed by using this Cron Job:
QUOTE
/usr/bin/mysqldump -ce --user=username_connection --password=xyxyxy username_database | gzip | uuencode cms_`date +\%d`.gz | mail -s 'Data Backup' backup@domain.com
From there it seemed such a simple progression to append the Table "products" to the database;
QUOTE
/usr/bin/mysqldump -ce --user=username_connection --password=xyxyxy username_database_products | gzip | uuencode cms_`date +\%d`.gz | mail -s 'Data Backup' backup@domain.com
However, that just results in an empty file being created and sent.
Has anyone please got any suggestions as to how this can be achieved.
