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

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

User, date Message
Written by Worried
1 year ago
Category: General
1 posts since Mon, 03 Jun 13
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?
Written by kalvaro
1 year ago
595 posts since Thu, 29 Nov 07
Most likely, it's an incorrect error message. There's nothing to optimize in a view.
Written by jfalchMoney, Euro
1 year ago
406 posts since Sat, 17 Oct 09
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.
Written by jfalchMoney, Euro
1 year ago
406 posts since Sat, 17 Oct 09
@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.