Re: Data folder copying problem
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 in database DB1. Then when I try to drop DB1, it issues error Unknown tables (T1, T2). If InnoDb own its table space... where is it reside ? Thanks Regards, Feris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Data folder copying problem
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Data folder copying problem
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 error Unknown tables (T1, T2). Why do you think it recognizes them? I have a database with only 1 table, but if I type this: drop table foo (foo doesn't exist) I get: #42S02Unknown table 'foo' Same error :-) If InnoDb own its table space... where is it reside ? I believe directly under the \data folder. Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Data folder copying problem
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]
Re: Data folder copying problem
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 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 error Unknown tables (T1, T2). Why do you think it recognizes them? I have a database with only 1 table, but if I type this: drop table foo (foo doesn't exist) I get: #42S02Unknown table 'foo' Same error :-) If InnoDb own its table space... where is it reside ? I believe directly under the \data folder. Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]