[OT] MySQL Health check?

Eric Schuele e.schuele at computer.org
Thu Oct 19 14:13:25 UTC 2006


Hello,

This is not a FreeBSD question... but The community is much more helpful 
than most, so I thought I'd try here.

I have MySQL server on my laptop.  Its just for play so not really 
worried about any data.  I recently portupgraded a ton of stuff.  Jumped 
though some unforeseen hoops and finally rebooted.  Upon reboot, the 
machine appeared to hang as XDM came up.  I eventually resorted to 
turning it off.  Brought it up in single user mode, and ran fsck.  fsck 
found some bad stuff on my /usr filesystem, all with owner mysql.  I 
selected yes to all clear/salvage options (right or wrong).  I had 
assumed mysql would be messed up but it "appears" fine.

So my MySQL question is...
How can I check/verify the overall health of MySQL?  Something like fsck 
for MySQL?

I have tried googling this, but frankly I don't even know what to google 
for, so I'm not finding much.

Thanks.
-- 
Regards,
Eric


More information about the freebsd-questions mailing list