Hello,

I would like to make daily automatic full backups of my
databases. I've read a few articles/books about that topic in several
documents without finding any acceptable solution. I'm able to backup
my Myisam and innodb tables by hand (with mysqldum) while keeping a
consistent state for each db.

Is it possible to automate that, ie to 1) make a list of all tables 2)
define for each table if it's an Innodb or Myisam one 3) backup each
table with mysqldump with the options needed by the format of the
table (myisam or innodb) ?

Thanks a lot for yor answer
-AJ