I've restored an MySQL backup from our MySQL server into another server. The backup includes InnoDB tables. After the import, MySQL recognized the innodb tables fine but when I try to do a check table ir returns that the table doesn't exists.
Permission and owner of the table files (.frm files) are ok, since it recognizes MyISAM tables (they have the same permission). Innodb engine is enabled..
Which can cause the tables to appears as "non existent", as far as they do really exist?
-- Att.* *** Luis H. Forchesatto http://br.linkedin.com/pub/luis-henrique-forchesatto/73/684/a67
Jul 22
Johan De Meersman Re: InnoDB problem.
Jul 22, 2013; 16:17
Johan De Meersman
Re: InnoDB problem.
Jul 23
Johan De Meersman Re: InnoDB problem.
Jul 23, 2013; 17:07
Johan De Meersman
Re: InnoDB problem.
Jul 23
Johan De Meersman Re: InnoDB problem.
Jul 23, 2013; 18:56
Johan De Meersman
Re: InnoDB problem.
Jul 23
Rick James RE: InnoDB problem.
Jul 23, 2013; 18:21
Rick James
RE: InnoDB problem.
Jul 23
Manuel Arostegui Re: InnoDB problem.
Jul 23, 2013; 22:05
Manuel Arostegui
Re: InnoDB problem.
Jul 23
Rick James RE: InnoDB problem.
Jul 23, 2013; 22:12
Rick James
RE: InnoDB problem.
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!