PDA

View Full Version : MySQL error on table "session"


angel2b
Fri 24th May '02, 4:05am
Checking the tables for consistency, one table, "session", returns an error on the CHECK query. And it does so for my own copy of vbulletin, as well as for a client I host.

My gut tells me this is probably not a severe error; just wanted to know whether this is a known issue.

Thanks!

- Mark

Chen
Fri 24th May '02, 4:28am
AFAIK, you can't CHECK HEAP tables. (and the session table is one)

eva2000
Fri 24th May '02, 4:39am
yup mysql CHECK command only works on myisam and innobase tables

REPAIR command only works on myisam tables

http://mysql.he.net/doc/C/H/CHECK_TABLE.html
http://mysql.he.net/doc/R/E/REPAIR_TABLE.html

Chen
Fri 24th May '02, 4:54am
Hey I was right. ;)