[OT] MySQL Health check?

2006-10-19 Thread Eric Schuele

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


Re: [OT] MySQL Health check?

2006-10-19 Thread Eric

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.



___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]


Re: [OT] MySQL Health check?

2006-10-19 Thread Eric Schuele

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]