Surf 11 » MySQL ERROR 1016 (HY000): Can't open file

Finding the best waves on the web.

I just got this error message on one of my mysql databases. It sounds kind of bad, but to fix it I just ran the following SQL statement, and all was well:

REPAIR TABLE tablename

The error might look like on MyISAM tables:

ERROR 1016 (HY000): Can't open file: 'tablename.myi' (errno: 1)

Or like this on InnoDB tables:

ERROR 1016 (HY000): Can't open file: 'tablename.InnoDB' (errno: 1)


Related Entries
On 01/02/2013 at 12:00:00 AM UTC Pete Freitag wrote:
1
I've also gotten this error: ERROR 1030 (HY000): Got error 127 from storage engine

Which can also be fixed by running a repair table command.

Name:

Email: (optional, not displayed on site)
   Subscribe to this thread
Comments: (html will be escaped)



Subscribe to our RSS Feed: subscribe to this feed XML
Archives   Tags   Contact