I have a group of databases I would like to backup regularly and send the sql backup as an email to the site owner.

The cron job I can set up. The email part I can do.

But does anyone know a simple way to ask a db in mysql to dump itself in a standard sql export format including db structure and records?

Thanks.