Hi Rick, Thanks... I think I found the answer from your direction. This article seems the solution to my problem :
http://dev.mysql.com/doc/refman/5.1/en/innodb-backup.html Thanks ! Feris On 1/31/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > moving an innodb table is trickier than moving a myisam one. you > might want to do a search like: > > moving innodb tables site:mysql.com > > in google. i think that the first couple of entries will give you > hints on what you need to do to accomplish this. > > - Rick > > ------------ Original Message ------------ > > Date: Thursday, January 31, 2008 09:00:38 PM +0700 > > From: Feris Thia <[EMAIL PROTECTED]> > > To: mysql@lists.mysql.com > > Subject: Data folder copying problem > > > > Hi all, > > > > 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. > > > > 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. > > > > > > ---------- End Original Message ---------- > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]