Cant open file in mySQL

I have taken a backup of my database and restored it onto our working server.

The restore seems to work fine till I try and open any of the tables.

I get :

Error no. 1016
Can't open file: tablename.MYI (errno:144)

I have had a look in "c:\mysql\data\mydatabase name\" and all the MYI files are there.

Any ideas ?

I am in deep poo if I cant get this working !

Go to the mysql bin folder (You know where that is, right?)

run

myisamchk.exe tablename

It'll give you info on the table... you should also try it with the corresponding .myd file

There are some switches in the myisamchk.exe utility that can attempt to fix the file for you.

Your quit clever, for a Frog.

Any luck?

Quote:

---

Originally posted by venerable bede
Your quit clever, for a Frog.

---

You're quite attractive, for a bede. ;)