Re: db messed up

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

 



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@xxxxxxxxxxxxx
>    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


-- 
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