missing .MYI files - need help!

I know the basics of mysql, and use phpmyadmin via my host.

I noticed several mysql errors on tiptopvillas.com recently (still there) which, when logged into phpmyadmin relate to missing .myi files. This isn't a problem with all my tables, i think the MyIsam ones are ok and the innodb ones have the problem. Whenever I click on a table name it says 'table.MYI' file missing. I contacted my host who basically said they hve no idea and I should hire someone to sort it out for me.

I do though, know enough about mysql to know that it is their fault nd most likely something happened to the server then saving teh database, or rebooting the server. I am at a bit of a loss with what to do, given my limited knowledge and my host's unhelpful response.

I searched these forums and found a similar thread where shawn suggested checking something bout runtime in phpmyadmin, but I don't get the option in phpmyadmin to check this and i don't know how to access the command line version of the mysal table to do it that way.

ANY help is really appreciated, I really need to get this fixed but feel like I keep running into brick walls!!

Cheers in advance guys.

 

try repairing your table, here is the syntax: http://dev.mysql.com/doc/refman/5.0/en/repair.html

 

I think you will have to deal with it from shell access (ssh). It is quite easy then. You will:
mysql
use table `table_name`;
repair table `table_name` USR_FRM;

 

is that the same as using 'repair' in cpanel? If so i have tried that and it didn't work, it said all was repaired but didnt actually do anything. Is there anything I can doo without shell access? I don't currently have it and I am pretty sure my host will not let me.

 

It is not the same. phpMyAdmin uses a regular repair:
repair table `table_name`;
But in most cases, the file could have been damaged and it needs to be restored from the frm file.

 

ok, thanks. my host is dragging their heels, mking it near impossible for me to do anyhting about this, especially without ssh access. will passthis info on though.

cheers.

 

ok, so i know i need to use those commanda mentioned above to fix this, but i dont have ssh access to the server.

For some reason my host won't even try this from their shell, and is simply saying that because I didnt back up the database myself there is nothing they can do about it.

I am at a bit of a loss as to what to do here, any suggestions anyone?

 

You can still execute that command via phpmyadmin using the sql query.

 

You said you have access to phpmyadmin? You can type the sql command there, no need for shell access.

 

thanks everyone, i hve tried doing the repair table command via phpmyadmin, as stated above. When i type:

REPAIR TABLE `availability` USR_FRM

for example, i get the following error:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'USR_FRM' at line 1

any ideas what I am doing wrong? Does it matter that all the damaged tables are innodb tables and not myisam?The myisam tables were unaffected.

thnks

 

REPAIR TABLE `availability` USR_FRM ;

what happens if you do a analyze ?

 

what is an analyze? sorry for the questions but as you may have guessed databases are not mystrong point!

 

ok, assuming you meant analyze `availability`; I get the following:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'availability`' at line 1

 

ok, analyze table availability gives a Msg_Type 'error' and Msg_Text 'can't find file availability.MYI (errno:2)

 

if you want to give me access I will try to help you... i think you are just not syntatically doing things properly (also my typo doesnt help =P )

 

thanks shoemoney, pm'ed you

 

I shot my mouth off not realizing I have to catch a plane to nyc in a few hours and am not finished packing... I think you will have to restore from a backup if you have one. It looks super weird.

 

ok, thanks for taking a look. I will hve to hound my host a bit more then i guess!! Super weird does not sound good argh!

have a nice flight!

 

are there any other myql peeps here that can offer any advice?

 

PM me the information and I will see what can be done.