I have no experience with mysql, my boss ran an optimise against the mysql database, against a bunch of views we got the msg_text '"tablexyz" is not BASE TABLE', the next has msg_text 'Corrupt'.
It seems to be only against views, we didnt get any of these error messages against the base tables.
Does this look like an incorrect error message, or do we have issues with our tables?
HeidiSQL - “Optimise” reporting view is not base table and corrupt
there is no such thing as an "incorrect error message". servers do not tell you such things for fun.
run a CHECK EXTENDED against your databases (Heidisql Tools / Maintenance / Maintenance tab; click on the left side to select DB(s)); if this should return error messages, try REPAIR EXTENDED on the defective items.
run a CHECK EXTENDED against your databases (Heidisql Tools / Maintenance / Maintenance tab; click on the left side to select DB(s)); if this should return error messages, try REPAIR EXTENDED on the defective items.
Please login to leave a reply, or register at first.