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>