Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 19 Oct 2006 09:19:32 -0500
From:      Eric <heli@mikestammer.com>
To:        FreeBSD Questions <freebsd-questions@freebsd.org>
Subject:   Re: [OT] MySQL Health check?
Message-ID:  <45378974.60204@mikestammer.com>
In-Reply-To: <453787A8.2050700@computer.org>
References:  <453787A8.2050700@computer.org>

next in thread | previous in thread | raw e-mail | index | archive | help
Eric Schuele wrote:
> 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.

google for

mysql repair database
mysql repair table

and you will get a ton of stuff about how to go about checking/repairing 
your data.  it depends on what kind of databases you have, etc. so you 
might have to view a few links.





Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?45378974.60204>