Date: Thu, 19 Oct 2006 09:55:45 -0500 From: Eric Schuele <e.schuele@computer.org> To: Eric <heli@mikestammer.com> Cc: FreeBSD Questions <freebsd-questions@freebsd.org> Subject: Re: [OT] MySQL Health check? Message-ID: <453791F1.1090104@computer.org> In-Reply-To: <45378974.60204@mikestammer.com> References: <453787A8.2050700@computer.org> <45378974.60204@mikestammer.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On 10/19/06 09:19, Eric wrote: > 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 > Yep.. that turned some good stuff up (`mysqlcheck -A`). Thanks. > 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. > > > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to > "freebsd-questions-unsubscribe@freebsd.org" > -- Regards, Eric
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?453791F1.1090104>