Hi, In our Company, we do regular backups of our databases. We always prefer to do a binary backup i.e shutdown mysql and do a tar-gz on the data dir. A perl process is spawned to do this via a crontab. I guess this is a safe and tested approach if you can spare the database to be down for some time.If you are using innodb , there is a mysqlhotcopy script that can do the backup.