This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line!
See this thread for details.
The moose likes JDBC and the fly likes ERROR 1016 (HY000): Can't open file: 'TABLE_NAME.InnoDB' (errno: 1) - MySQL Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "ERROR 1016 (HY000): Can Watch "ERROR 1016 (HY000): Can New topic
Author

ERROR 1016 (HY000): Can't open file: 'TABLE_NAME.InnoDB' (errno: 1) - MySQL

Rogerio Kioshi
Ranch Hand

Joined: Apr 12, 2005
Posts: 655
posted private message
0
Quote
Hi,

I'm getting the following message when executing this command in MySQL:

Select * from TABLE_NAME

The message shown is:
ERROR 1016 (HY000): Can't open file: 'TABLE_NAME.InnoDB' (errno: 1)


How to solve?

SCEA 5 (part 1), SCBCD, SCWCD, SCJP, CLP, CLS
Stephan Mueller
Ranch Hand

Joined: May 05, 2010
Posts: 49
posted private message
0
Quote
Google reveals possible cause: OS error - too many open files
http://www.canbal.com/view.php?sessionid=QXAKGF8bo0iKm3xQWv5q4LmXJOfaVWI86pyRZoKCG9Q%3D

See if you can make use of this - I can't do anything, besides googling for you.

1. Make it run - 2. Make it run correctly - 3. Make it pretty OR fast/small - 4. ??? - 5. Profit
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ERROR 1016 (HY000): Can't open file: 'TABLE_NAME.InnoDB' (errno: 1) - MySQL
 
Similar Threads
SQL Error
Three problems with mysql...
How to install "Fast Debugger" using Netbeans as IDE for Ruby?
MySQL localhost
Installing mysql on Linux