> I have 2 database folder that being copied directly from a remote
> server and sent to me. That databases contains both MYISAM and INNODB
> After I received the data, I try to restored it by copying that
> folders to my server. The problem is, only MYISAM tables are being
> recognized. How come ? I check mysql server storage engine status and
> INNODB is being enabled and active.
By default, InnoDB tables aren't stored in the database folder, but rather
in it's own table space files.
> Then I try to drop those databases, but every drop attempt will cause
> "unknown tables ... " error.
> Is my restoration problem has to do with some user permission or it is a
> For your information, both the database server use mysql
> 5.0.45-community-nt version.
Database Workbench - development tool for MySQL, and more!
Database development questions? Check the forum!