[OT] MySQL Health check?
Eric Schuele
e.schuele at computer.org
Thu Oct 19 14:55:47 UTC 2006
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 at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to
> "freebsd-questions-unsubscribe at freebsd.org"
>
--
Regards,
Eric
More information about the freebsd-questions
mailing list