I guess you could say that. The machine is Redhat 9 too. I logged in locally and connected to the mysql server fine. Everything had appeared as normal. I could see all the databases, and \u to them.
Is there a way I can turn on some extended logging to get more info on the problem as it will probably arise again in the future? Thx- Matt On Tue, 2003-11-11 at 21:35, Matt W wrote: > Hi Matt, > > So one database "disappeared" all of a sudden while the others are OK? > Is MySQL running on FreeBSD? If so, that'll be the problem :-) and we'll > point you toward the fix. > > > Matt > > > ----- Original Message ----- > From: "Matt Babineau" > Sent: Tuesday, November 11, 2003 3:28 PM > Subject: RE: Mysql just stopped working on my server - any way to track > down the problem? > > > > Its not a startup problem, that works fine. What happened was my php > > application stopped working. This server has multiple databases on it > > mind you. The other databases were working fine. > > > > So one database stopped working and the application could not connect > to > > it. so I did a 'service mysql restart' and it started working again > like > > magic. I looked in the .err file and it only shows when the mysql > server > > stops and starts. I can't see the file on this machine, but it just > > seems to be logging starts and stops. > > > > Thanks for the reply hope this helps- > > > > Matt > > > > On Tue, 2003-11-11 at 19:20, Dathan Vance Pattishall wrote: > > > Can you post what the *.err file said? A key/value in /etc/my.cnf > might > > > be causing a startup problem. > > > > > > > > > - Dathan Vance Pattishall > > > - Sr. Programmer and mySQL DBA for FriendFinder Inc. > > > - http://friendfinder.com/go/p40688 > > > > > > > > > -->-----Original Message----- > > > -->From: Matt Babineau [mailto:[EMAIL PROTECTED] > > > -->Sent: Tuesday, November 11, 2003 1:16 PM > > > -->To: [EMAIL PROTECTED] > > > -->Subject: Mysql just stopped working on my server - any way to > track > > > down > > > -->the problem? > > > --> > > > -->Hi All- > > > --> > > > -->I am running 4.0.15-standard on RH9. My mysql database just > stopped > > > -->working, is there a way I can log information about why it stops > like > > > -->this? the *.err was unhelpful. > > > --> > > > -->Any help here is appreciated. Thanks > > > --> > > > -->-Matt > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
