Here's what I do via cron with mysql for one of my servers:
Code:
20 21 * * * mysqldump -u backup client_hightech | gzip -v9 - > /var/www/clients/nightlies/hightech_nightly.sql.gz
20 21 * * * mysqldump -u backup client_clinicazhen | gzip -v9 - > /var/www/clients/nightlies/clinicazhen_nightly.sql.gz
20 21 * * * mysqldump -u backup client_ics | gzip -v9 - > /var/www/clients/nightlies/ics_nightly.sql.gz
You could add more to it like date/timestamp, if you wanted.