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/[EMAIL PROTECTED]