Stephen, mysqlcheck works while the server is running. P. ----------------
Gerald Clark wrote: > Do not run myisamchk with the server running. > > Stephen Sokalski wrote: > > > version: 3.23.37 running on an RAQ > > Problem: I can not log into MySql as root - it hangs after I give it > > a password. > > Background: MySql was running fine for a year and then just stopped > > running. > > > > Symptoms: 1) Mysqld is running when I reboot the server but can't be > > shut down (/usr/share/mysql/mysql.server stop) and keeps timing out. > > 2) When it's running there is a .sock file > > 3) If I try to log in as any valid user, it simply waits indefinitely. > > 4) Suspecting that something is wrong with the mysql database, I ran a > > check on it: > > myisamchk -f *.MYI and > > myisamchk -r *.MYI > > Every time I run the -r it states it's repairing indexes. > > > > In any event: > > I know I should probably upgrade the version but it was a "package" > > that was suggested by sun at the time and I know I could > > download the binary but ... I want to make sure I understand what the > > problem is and know that I will be able to fix it by upgrading. > > > > Can someone explain what is going on? Will upgrading fix this > > problem, etc.? > > > > Thanks, > > Steve > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
