Error....1016 Can't open file: 'sessions.MYI'

[enchantedone]

hi i hope I'm putting this in the right forum. I'm having a bit of a problem, i was doing last minute things to my cart today and all of a sudden i get this message

1226 User 'enchante' has exceeded the 'max_questions' resource (current value: 50000)
in:
[select value from sessions where sesskey = 'f98108328df1cd55fd04ed95' and expiry > '1148489993']

so i look here and find out that its a problem with my host "startlogic" limiting me so i contact them through chat and he clears the catch for me. As if this is not a big enough problem that they limit me this much it happens again in 1 hour so i contact them again and once again they fix it, but this time after they fix it i get this message

1016 Can't open file: 'sessions.MYI'. (errno: 145)
in:
[select value from sessions where sesskey = '5bb9cc794bbc5fda10af6e082' and expiry > '1148512101']

so i contact startlogic again and they actually cant help me as he doesn't know whats going on so i email support and still no reply, my site has been down all day. so i looked here and found a few threads that said to try and repair it but so i go to php my admin and it shows that there is in fact an error, but there is no where to repair it, i have looked everywhere. that was the only thing i could find about fixing this.

does anyone know how i can fix this or do ineed to reupload my database.
i made a bunch of changes today to the database so i'm afraid of losing it all, i was going to back up the database as soon as i finished but this happened in the mean time.

any help would be so appreciated.

thanks so much

[Kim]

Empty your sessions table in the database, then run the repair tool in phpmyadmin.

[enchantedone]

kim,

thanks for the help.

thats what i have been trying to do but for some reason i cant find the sessions table or the repair tool.

maybe im doing something wrong.
would you mind explaining how to go about it.

this seems like it would be easy to do, but i cannot for the life of me find how to delet the sessions contents

thanks so much

[enchantedone]

after looking again i notice its not showing the sessions table and all the other table after the sessions table

[enchantedone]

i got it. i wasnt able to empty the table so i backed it up deleted the whole database and reuploaded it then added the sessions table.

thanks

[Ajeh]

Thanks for the update on how you were able to repair your damaged database ... it will be of help to others in the future ...

Be sure to keep good backups!

[pinkbeef]

I had the same problem but managed to get PHPmyadmin to repair the table. but the repair message i got from PHPMy Admin was that there was now 7 entrys and not 6, is that a problem

[Ajeh]

The sessions table cleans out on a regular basis ...

You could actually empty it ... but note that if anyone is online it will delete their session ...

Usually this error is the result of the MySQL server crashing ...

This should not happen, and as long as it is not a recurring problem you should be okay ...

Check with your hosting site to see if they can shed any light on why this may have happened ...

[stevehare]

I know this thread is a bit old but I encountered the problem today.

Yesterday the site was down (as were several others on the same server), so I'm assuming their servers crashed. Then today the sites were back up but when I went to the cart I got the 1016 Can't open file: 'sessions.MYI' error.

After talking with my hosts tech support team, I was very frustrated and searched and of course I come across this thread and the solution...though I used another source too.

Here's what I did to EASILY fix the problem:

From phpMyAdmin I clicked the SQL tab and typed in this:

REPAIR TABLE sessions;

I clicked go and the table was repaired and my cart was again in business.

[Ajeh]

Glad you are up and running ...

Might want to be running for a new hosting site that has a clue such as our Certified Hosting sites ...