From owner-freebsd-questions@FreeBSD.ORG Thu Oct 19 14:20:44 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 67B3716A403 for ; Thu, 19 Oct 2006 14:20:44 +0000 (UTC) (envelope-from heli@mikestammer.com) Received: from smtp101.sbc.mail.re2.yahoo.com (smtp101.sbc.mail.re2.yahoo.com [68.142.229.104]) by mx1.FreeBSD.org (Postfix) with SMTP id 3B04C43D80 for ; Thu, 19 Oct 2006 14:19:36 +0000 (GMT) (envelope-from heli@mikestammer.com) Received: (qmail 71034 invoked from network); 19 Oct 2006 14:19:34 -0000 Received: from unknown (HELO mail.mikestammer.com) (mikestammer@sbcglobal.net@70.131.101.46 with login) by smtp101.sbc.mail.re2.yahoo.com with SMTP; 19 Oct 2006 14:19:34 -0000 Received: from localhost (localhost [127.0.0.1]) by mail.mikestammer.com (Postfix) with ESMTP id 727FD7B for ; Thu, 19 Oct 2006 09:19:34 -0500 (CDT) X-Virus-Scanned: amavisd-new at mikestammer.com Received: from mail.mikestammer.com ([127.0.0.1]) by localhost (gondolin.middleearth.mikestammer.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 036qK8rbRhi5 for ; Thu, 19 Oct 2006 09:19:33 -0500 (CDT) Received: from [127.0.0.1] (localhost [127.0.0.1]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: eric) by mail.mikestammer.com (Postfix) with ESMTP id 12FF175 for ; Thu, 19 Oct 2006 09:19:32 -0500 (CDT) Message-ID: <45378974.60204@mikestammer.com> Date: Thu, 19 Oct 2006 09:19:32 -0500 From: Eric User-Agent: Thunderbird 1.5.0.7 (Windows/20060909) MIME-Version: 1.0 To: FreeBSD Questions References: <453787A8.2050700@computer.org> In-Reply-To: <453787A8.2050700@computer.org> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit 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:20:44 -0000 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.