On 21 Jul 2006 14:49:17 +0200, Antoine Junod wrote:
> 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) ?

Which of the above does mysqldump *not* do for you?

--
58. If it becomes necessary to escape, I will never stop to pose dramatically
and toss off a one-liner.
--Peter Anspach's list of things to do as an Evil Overlord