db messed up

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