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
"[EMAIL PROTECTED]"
--
Regards,
Eric
_______________________________________________
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"