mysqlhotcopy only with myisam???

[hanskopf]

Hello all together,

my question is, if the mysqlhotcopy perl script does realy onyl work with MyIsam/ISAM tables? I'm asking this question because the english manual page (http://dev.mysql.com/doc/mysql/en/mysqlhotcopy.html) says that it only works with these table engines but the german manual page (http://dev.mysql.com/doc/mysql/de/mysqlhotcopy.html) doesn't say a word on supported storage engines. Also in the German version of the MySQL Tutorial Book (Luke Welling and Laura Thomson) there is nothing mentioned about the supported engines. But in the english "MySQL Administrators Guide" Book is said, that only MyISAM and ISAM tables can be backed up.

So I just tried it with 6 InnoDB tables in a small test database (the employee DB from the tutorial) and all the necessary .frm and the db.opt file were copied to the specified directory. So it worked correctly with the innoDB tables, or am I wrong?

It would be greate if there is anyone who can tell me what is really true with the mysqlhotcopy script.

Thanks in advance
Hans