Re: db messed up

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