MySQL backup cron job not working

[mrnabo]

Hi,

Not sure if this is the correct forum for this, so apologies if not.

I'm trying to get my Cron job working in cPanel and everything is working ok except I need to email the database to my client:

mysqldump -u USERNAME -pPASSWORD DATABASENAME | gzip > /home/USERNAME/bkups/mysql-$(date +\%Y-\%m-\%d-\%H.\%M.\%S).gz

Does anyone know how I can modify the code above to instruct cron to email te database?

Thanks

[Spiral]

I'm trying to get my Cronjob working in cPanel and everything is working ok except I need to email the database to my client:

Why does your client need the database sent by email?

That does seem a bit peculiar and if their intention is simply keeping
backups, there is much better ways of doing all of that.