Re: db messed up

On Tue, 2009-05-26 at 15:53 -0400, PJ wrote: > Ashley Sheridan wrote: > > On Tue, 2009-05-26 at 15:37 -0400, PJ wrote: > > > >> I am probably not doing this right, but where else can I turn (don't > >> answer that!)... > >> this morning my wonderful local conEdison decided they were going to > >> waste my day by shutting off the power exactly as I was booting up my > >> server. > >> Hence, I cannot access a critical database... fortunately, I can redo > >> the database, but I'd like to know what I can to to fix the problem... > >> All other databases are functioning ok. Server is running ok, > >> > >> mysql> CHECK TABLE producer; > >> ERROR 2006 (HY000): Mysql server has gone away > >> No connection. Trying to reconnect... > >> Connection id: 1 > >> Current database: theproblem-one > >> Error 2006 (HY000: Mysql server has gone away > >> ERROR 2002 (HY000): Can't connect to local MySQL server through socket > >> '/tmp/mysql.sock' (61) > >> ERROR: Can't connect to the server > >> mysql> > >> > >> 090526 11:27:47 [Note] /usr/local/libexec/mysqld: ready for connections. > >> Version: '5.1.34' socket: '/tmp/mysql.sock' port: 3306 FreeBSD > >> port: mysql-server-5.1.34 > >> 090526 11:32:14 [Note] /usr/local/libexec/mysqld: Normal shutdown > >> > >> This was the time of the problem! > >> But when I look at /tmp/mysql.sock - it is 0 bytes. > >> Is this the problem? But I can connect to the other databases... :'( > >> > >> -- > >> Hervé Kempf: "Pour sauver la planète, sortez du capitalisme." > >> ------------------------------------------------------------- > >> Phil Jourdan --- pj@ptahhotep.com > >> http://www.ptahhotep.com > >> http://www.chiccantine.com/andypantry.php > >> > >> > >> > > Have you tried to repair the table? I've only had to ever repair one > > table (thankfully!) but the syntax I used was REPAIR TABLE tablename > > > > > > Ash > > www.ashleysheridan.co.uk > > > > > > > Somehow, I knew you would come through :-) > I'm afraid that there seems to be no way to connect to that particular > database. > I've tried about everything I could find on the web, the manuals, etc. > Since the server is running, mysql is running, the other databases > connect and execute. So, I suppose the only option is to try to create a > new dataabase and probably delete the old stuff from the machine. ??? > > -- > Hervé Kempf: "Pour sauver la planète, sortez du capitalisme." > ------------------------------------------------------------- > Phil Jourdan --- pj@ptahhotep.com > http://www.ptahhotep.com > http://www.chiccantine.com/andypantry.php > > I can't find anything that will repair a whole database, only individual tables. It's odd that you can't even connect to the database at all, :-/ Ash www.ashleysheridan.co.uk