From: Martijn Tonies
Date: January 31 2008 2:07pm
Subject: Re: Data folder copying problem
List-Archive: http://lists.mysql.com/mysql/211161
Message-Id: <02a401c86412$a287d920$9902a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi,

> I have 2 database folder that being copied directly from a remote
> server and sent to me. That databases contains both MYISAM and INNODB
> tables.
>
> 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
bug ?
>
> For your information, both the database server use mysql
> 5.0.45-community-nt version.

Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com