Can’t find file: *.MYI (errno: 2)

9 May

If you get:  Can't find file: 'myTable.MYI' (errno: 2)

It means MYI file is missing – this is okay, it can be rebuilt.

try to run (in mysql):
repair table myTable;

if you get the same error as above, run it as:
repair table myTable USE_FRM;

this should rebuild MYI  (which is an index file).

You'll have to make sure the MYD file is okay and in /var/lib/mysql/<database>

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: