Re: db messed up

Ashley Sheridan wrote: > On Tue, 2009-05-26 at 15:53 -0400, PJ wrote: > >> Ashley Sheridan wrote: >> >>> 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 >>> >>> >>> >>> >> Somehow, I knew you would come through :-) >> I'm afraid that there seems to be no way to connect to that particular >> database. >> I've tried about everything I could find on the web, the manuals, etc. >> Since the server is running, mysql is running, the other databases >> connect and execute. So, I suppose the only option is to try to create a >> new dataabase and probably delete the old stuff from the machine. ??? >> >> -- >> 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 >> >> >> > I can't find anything that will repair a whole database, only individual > tables. It's odd that you can't even connect to the database at all, :-/ phpMyAdmin closes when trying to access that db and asks for a login. I'll try to finagle things the old band-aid way and try to recreate the damned thing... maybe, if I delete it all (backups, of course) and the create a new db with same name & then repopulate it with the existing files... who knows... Thanks, as always.. Phil -- 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