Can"t open MYI file

-------------------------------1128101915
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit

I have a data base with a table called 'employees'.

Right now, whenever I perform any SQL command against that table (select,
describe. etc), I get the following message:

ERROR 1016: Can't open file : 'employees.MYI'. (errno 145)

Any suggestions on restoring the table welcome.

Tom Freund

-------------------------------1128101915--

Re: Can"t open MYI file

You could use the CHECK, OPTIMIZE and REPAIR stuff to try and get the
table back in order. If you recreate the indexes, you'll probably
"rebuild" the missing file. Check the manual for the syntax or you can
use MySQL Administrator to perform this.

I wonder what happened for you to loose the indexes file, but whatever
it was, at least you still have (I hope) the MYD file, because that's
where the real data is.

Good luck,

On 9/30/05, WriteNCook@aol.com wrote:
> I have a data base with a table called 'employees'.
>
> Right now, whenever I perform any SQL command against that table (select,
> describe. etc), I get the following message:
>
> ERROR 1016: Can't open file : 'employees.MYI'. (errno 145)
>
> Any suggestions on restoring the table welcome.
>
> Tom Freund
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org