Re: Data folder copying problem

2008-01-31 Thread Feris Thia
Hi Martin, You are correct. That's the same error that I got. Looks like this article is the solution => http://dev.mysql.com/doc/refman/5.1/en/innodb-backup.html Thanks ! Feris On 1/31/08, Martijn Tonies <[EMAIL PROTECTED]> wrote: > Hi, > > > > By default, InnoDB tables aren't stored in the d

Re: Data folder copying problem

2008-01-31 Thread Feris Thia
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

Re: Data folder copying problem

2008-01-31 Thread Martijn Tonies
Hi, > > By default, InnoDB tables aren't stored in the database folder, but rather > > in it's own table space files. > > > > In fact when I try to drop the database, the server "recognizes" > innodb tables. For example, T1 and T2 are INNODB tables in database > DB1. Then when I try to drop DB1, i

Re: Data folder copying problem

2008-01-31 Thread Feris Thia
Hi Martin, On 1/31/08, Martijn Tonies <[EMAIL PROTECTED]> wrote: > Hi, > > By default, InnoDB tables aren't stored in the database folder, but rather > in it's own table space files. > In fact when I try to drop the database, the server "recognizes" innodb tables. For example, T1 and T2 are INNOD

Re: Data folder copying problem

2008-01-31 Thread Martijn Tonies
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 > recog