Re: mysqldump --opt crashes server on InnoDB tables

[Tobias Asplund]

On Fri, 24 Sep 2004, Thomas Plümpe wrote:

>   mysql> CREATE DATABASE myinnotest;
>   mysql> CREATE TABLE myinnotest.t (id INT) TYPE=InnoDB;
>   $ mysqldump -uroot --opt myinnotest > myinnotest.sql
>   mysqldump: Can't get CREATE TABLE for table `t` (Lost connection to
>   MySQL server during query)


you usually get this error when you have the .frm file for the table in
question, but there's nothing recorded in the InnoDB tablespace corresponding
to it.

ie, if you do a filecopy on the database directories under your data-dir, but
not with InnoDB Hot Backup or similiar to the InnoDB tablespace.