Re: db messed up

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... :'( > Been a while for me on BSD, but try: /usr/local/etc/rc.d/mysql-server stop rm /tmp/mysql.sock /usr/local/etc/rc.d/mysql-server start -- Thanks! -Shawn http://www.spidean.com