phpMySQLAutoBackup exports your database (data and structures), compresses it into gzip format and emails to you. schedule it to run every day/week by adding it to a cron job.

Free download at: http://www.dwalker.co.uk