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 INNODB tables

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 recognized.

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.

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, it issues

Re: Data folder copying problem

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

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 database