Unix Technical Forum

Check all databases health

This is a discussion on Check all databases health within the MySQL General forum forums, part of the MySQL category; --> Hi, I am getting a lot of these ones after a power outage. I have a huge amount of ...


Go Back   Unix Technical Forum > Database Server Software > MySQL > MySQL General forum

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 07:00 AM
Peter Lauri
 
Posts: n/a
Default Check all databases health

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




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:18 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com