InnoDB - mysqldump

[Rafal Kedziorski]

hi,

we have problems with import our dumped InnoDB tables.

We get this error message:

"Can't create table '.\mmcms_test\media_lock.frm' (errno: 150)"

My tables which will be referenced by foreign keys will be dumped in the
inncorect order.

if I set:
SET FOREIGN_KEY_CHECKS=0;

sql script

SET FOREIGN_KEY_CHECKS=1;

Than import works. What is the best way to dump and import InnoDB tables.
Regards,
Rafal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw