help error mysql

[oxblood12]

hello, my forum generates an error of mysql, the error is the following one:

PHP Code:

consulta SQL:  

SHOW INDEX FROM `user` ;



MySQL ha dicho:  

#1017 - Can't find file: 'user' (errno: 2) 


I cannot endorse, and in the visualization the table this in use leaves ke to me, when repairing says that this corrupt one to me:

REPAIR TABLE user 

Table                   Op              Msg_type  Msg_text  
dbname.user       repair         Error Can't find file: 'user' (errno: 2) 
dbname.user       repair         error Corrupt

[Dismounted]

It appears the the whole user table is either corrupted, or does not exist at all.

[Amenadiel]

are you sure the table user exists? shouldn't be "vb_user"?

you can try exporting it to a .sql dump, then dropping it, restarting mysql service and importing it to a new table in which you should recreate indexes