List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:January 31 2008 2:07pm
Subject:Re: Data folder copying problem
View as plain text  
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

Thread
Data folder copying problemFeris Thia31 Jan
  • Re: Data folder copying problemMartijn Tonies31 Jan
    • Re: Data folder copying problemFeris Thia31 Jan
  • Re: Data folder copying problemMartijn Tonies31 Jan
    • Re: Data folder copying problemFeris Thia31 Jan
Re: Data folder copying problemFeris Thia31 Jan