After looking up the module on CPAN, I think I wouldn't mind using it on my own personal databases. However, if my job was on the line and I were asked to backup a database consisting of 225 tables and 100k records, I would bite the bullet and use mysqldump.

If you really want to use perl for this task, why don't you call mysqldump in a perl script that passes it variables specific to your database and run it as a cron job?

It looks like a good module but I'm not sure if its "production ready".

-Actualize