Hi Guys,
One of my clients has recently purshased a package at a netregistry, because of there australian payment gateway.
The Customer has cron and ftp access, and wanted to automate a daily backup of his customers accounts.

so far i have the following code i have worked out:
Code:
mysqldump --all-databases --add-drop-table -c -f -F -a -q -u USERNAME --password="PASSWORD" > /home/aussiestore/`date '+%Y%m%d'`.sql 
gzip /home/aussiestore/`date '+%Y%m%d'`.sql
now i need to get it to ftp `date '+%Y%m%d'`.sql.gz to my server.
Please NOTE: His ftp is username and passworded, so please refer to in example.
then
Code:
rm -rf `date '+%Y%m%d'`.sql.gz
Thanks in advance.