Check all databases health

[Peter Lauri]

Hi,

 

I am getting a lot of these ones after a power outage. I have a huge amount
of tables and databases on the server. Is there any automated way to check
the health of ALL databases and ALL tables? And maybe some automated way to
repair if problems?

 

Got error: 1016: Can't open file: 'guestbook.MYI' (errno: 145) when using
LOCK TABLES

 

Best regards,

 

Best regards,

Peter Lauri

 

 <http://www.dwsasia.com/> www.dwsasia.com - company web site

 <http://www.lauri.se/> www.lauri.se - personal web site

 <http://www.carbonfree.org.uk/> www.carbonfree.org.uk - become Carbon Free