This is an easy-to-use plugin to quickly backup your WordPress database. You may download the backup file, or have it emailed to the address of your choice. By default, the core WordPress tabels are backed up.
You may select additional tables, if any, and choose how you’d like to receive your backup file. This may also be used with the WP-Cron package from Skippy to receive daily backups automatically to your email. Thanks Photomatt
[EDIT] From Dougal: Perl Script to backup and email MySql Databases
I use a perl script to back up my set of databases, and it emails a tarball to my Gmail account for offsite backup.
My database backups have saved my butt a couple of times in the past 🙂
Recently my website got hacked. I somehow recovered it. Still I am in a fear of a hack. How should I backup all my contents including all my post and images? Please tell me the difference between database and wordpress tables backup ? I am using bigrock for file hosting …in my bigrock account there is a database backup option. My 6 month backup is around 175 MB. It is a winrar file. Is that file enough to recover all my website contents to back when it got hacked? How we can perform a backup using PhpMyadmin?