• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Rogerio Kioshi
Ranch Hand
Posts: 690
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Stephan Mueller
Ranch Hand
Posts: 50
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic