how to get MYI files in mysql

[smagdy]

am using mysql so my tables have this format *.frm but i installed apache+mysql+php+phpMyAdmin latest versions so when i try to access my tables from phpMyAdmin it says:

#1017 - Can't find file: 'table.MYI' (errno: 2)

so how to make them *.MYI

thanks

[txbakers]

You don't make them MYI by yourself.

When you create a table using the proper SQL commands, mySQL will generate the three file types for you.

[jorj]

try the repair command. It may recreate that file for you.

[smagdy]

how can i use the repair comand in phpmyadmin?

[coopster]

The .myi extension indicates [dev.mysql.com] an index file. At one point you must have had an index and MySQL is now trying to use it, but cannot find it. Perhaps you could restore it from a backup or recreate the index.

[smagdy]

i have lot of backup and nothing have that index cuz i didnt create any index so how to restore it or recreate it or anything to get those extra files plz help..

i know we can repair the table how to do it.. whats the command

[coopster]

The MySQL manual ;)

How to Repair Tables [dev.mysql.com]