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

Filtering Maintenance results

User, date Message
Written by djdjohnson
3 years ago
Category: Feature discussion
66 posts since Mon, 28 Jun 10
One of our servers has about 8000 tables on it. Periodically I run a database check on it to make sure that everything is working right. HeidiSQL handles this fine for the most part, but trying to find the 'corrupt' entries in a list that long is time consuming and tricky.

Would it be possible to add an option that doesn't include the "OK" results in the result list? It would be much easier to find the tables that need to be repaired if only the damaged tables show up in the results.

-AND-

Could you add an 'auto-repair' option to the Check operation when it encounters a corrupted table? Even if the check results don't include all of the 'OK' results I still have to scroll through the table list and select all of the tables that need to be repaired.
Written by ansgar
3 years ago
5045 posts since Fri, 07 Apr 06
Did you know you can sort that result list by clicking a column header? Should help you in finding the broken tables.

For the auto-repair, I'm a bit undecided and I'm unsure if I'm able to detect a broken, repairable table. Please some hints.
Written by djdjohnson
3 years ago
66 posts since Mon, 28 Jun 10
When a table has become corrupted and needs to be repaired, Msg_type=error, Msg_text=Corrupt.
 

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