Kishor, are you running on Windows? There is a bug in the current Windows version which requires that you always specify the database name in lower case. Otherwise you are not able to access your table.
See also http://www.innodb.com/ibman.html the section about troubleshooting data dictionary operations. It is relevant on both Unix and Windows. >hi, >I have been using mysql isam tables for a while. >Today i installed mysql3.23.44 and created the example table customer in the >test database. >But when i do a select or insert for this table i am getting the followingerror. >Can't open file: 'customer.InnoDB' >Any ideas? > >Kishor Regards, Heikki --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php