How to backup a mix from InnoDB- and MyISAM-tables ?

Hi,

I have the problem that i have to backup several databases who include a mi=
x of InnoDB- and MyISAM-tables.
I'd like to use mysqldump. The manpage proposes different options for MyISA=
M- and InnoDB-tables. What is about --single-transaction ? --single-transac=
tion is recommend for InnoDB-tables. MyISAM-tables are not dumped in a cons=
istent state using this option, so it's not the optimum for my scenario. Is=
--single-transaction a recommendation for InnoDB-tables or is it a must ?

What is about --lock-all-tables ? The manpage says --single-transaction is =
a much better option for InnoDB-tables (see above). But does --lock-all-tab=
les work with InnoDB-tables ? The manpage also says: "This is achieved by a=
cquiring a global read lock for the duration of the whole dump." Does that =
mean that also reading is locked, or does it mean that it is locked to enab=
le reading ?
Currently i have the impression that --lock-all-tables is the better way fo=
r me dumping databases including both types of tables.


Thanks for any answer.

Bernd

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg