help error mysql

[oxblood12]

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


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