db messed up

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxx
   http://www.ptahhotep.com
   http://www.chiccantine.com/andypantry.php


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux