From owner-freebsd-questions@FreeBSD.ORG Thu Oct 19 14:55:47 2006 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 9EAEF16A403 for ; Thu, 19 Oct 2006 14:55:47 +0000 (UTC) (envelope-from e.schuele@computer.org) Received: from sccrmhc12.comcast.net (sccrmhc12.comcast.net [204.127.200.82]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3DFF143D46 for ; Thu, 19 Oct 2006 14:55:47 +0000 (GMT) (envelope-from e.schuele@computer.org) Received: from [208.206.151.59] (host59.gtisd.com?[208.206.151.59]) by comcast.net (sccrmhc12) with ESMTP id <20061019145546012001qi0ie>; Thu, 19 Oct 2006 14:55:46 +0000 Message-ID: <453791F1.1090104@computer.org> Date: Thu, 19 Oct 2006 09:55:45 -0500 From: Eric Schuele User-Agent: Thunderbird 1.5.0.7 (X11/20061018) MIME-Version: 1.0 To: Eric References: <453787A8.2050700@computer.org> <45378974.60204@mikestammer.com> In-Reply-To: <45378974.60204@mikestammer.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Cc: FreeBSD Questions Subject: Re: [OT] MySQL Health check? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 19 Oct 2006 14:55:47 -0000 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