From owner-freebsd-questions@FreeBSD.ORG Thu Oct 19 14:13:25 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 B010216A4B3 for ; Thu, 19 Oct 2006 14:13:25 +0000 (UTC) (envelope-from e.schuele@computer.org) Received: from rwcrmhc15.comcast.net (rwcrmhc15.comcast.net [204.127.192.85]) by mx1.FreeBSD.org (Postfix) with ESMTP id 02CA243DBA for ; Thu, 19 Oct 2006 14:11:57 +0000 (GMT) (envelope-from e.schuele@computer.org) Received: from [208.206.151.59] (host59.gtisd.com?[208.206.151.59]) by comcast.net (rwcrmhc15) with ESMTP id <20061019141153m15008r3i9e>; Thu, 19 Oct 2006 14:11:53 +0000 Message-ID: <453787A8.2050700@computer.org> Date: Thu, 19 Oct 2006 09:11:52 -0500 From: Eric Schuele User-Agent: Thunderbird 1.5.0.7 (X11/20061018) MIME-Version: 1.0 To: FreeBSD Questions Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: [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:13:25 -0000 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. -- Regards, Eric