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

[expired user #6989]'s profile image [expired user #6989] posted 11 years ago in General Permalink
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's profile image kalvaro posted 11 years ago Permalink
Most likely, it's an incorrect error message. There's nothing to optimize in a view.
jfalch's profile image jfalch posted 11 years ago Permalink
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's profile image jfalch posted 11 years ago Permalink
@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.