MySQL table showing in "show tables" but not accessible, I don't know what to do

vps

#1

Hi,
in my VPS mysql server I can’t access anymore a table, a simple
select count(*) from table
doesn’t work (makes me wait for minutes without answering).

If I run:
show open tables from mentorfm where in_use = 1;
I see the table, but with “name_locked” to 0

I guess the problem was in a massive insert script I run during the night, this morning for some reason I found it stopped…the script has a START TRANS at the very beginning and a COMMIT at the end and it takes hours to be executed, but normally the execution continue until the end.

What can I do with this table?

Thanks