distal-attribute
distal-attribute
distal-attribute
distal-attribute

HeidiSQL - “Optimise” reporting view is not base table and corrupt

Worried posted 2 years ago in General
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?
kalvaro posted 2 years ago
Most likely, it's an incorrect error message. There's nothing to optimize in a view.
jfalch posted 2 years ago
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.
jfalch posted 2 years ago
@kalvaro: unfortunately (for me), you are right, and this _is_ the first incorrect error mesasge i have seen from mysql server. optimizing a freshly defined view returns the same messages "not a base table" / "corrupt". apologies, i was wrong.

Please login to leave a reply, or register at first.