Re: db messed up

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