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
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 cop

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

Data folder copying problem

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