Re: [PHP] db messed up
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 --- p...@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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] db messed up
[snip] ...this morning my wonderful local conEdison ... [/snip] [snip] ... Hydro Quebec just f***ed my server just as I was booting... [/snip] I see that you asked this on the MySQL list which would be the correct place to do this. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] db messed up
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 --- p...@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 --- p...@ptahhotep.com 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
Re: [PHP] db messed up
Jay Blanchard wrote: [snip] ...this morning my wonderful local conEdison ... [/snip] [snip] ... Hydro Quebec just f***ed my server just as I was booting... [/snip] I see that you asked this on the MySQL list which would be the correct place to do this. As you are aware, you have nothing to offer, for if you did, you would have posted it on the MySQL list. So why are you butting in? I know what I am doing and where to look for help... obviously, the other list isn't as knowledgable as is this one. :-P -- Hervé Kempf: Pour sauver la planète, sortez du capitalisme. - Phil Jourdan --- p...@ptahhotep.com 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
Re: [PHP] db messed up
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 --- p...@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 --- p...@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, :-/ Ash www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] db messed up
[snip] As you are aware, you have nothing to offer, for if you did, you would have posted it on the MySQL list. So why are you butting in? I know what I am doing and where to look for help... obviously, the other list isn't as knowledgable as is this one. :-P [/snip] Oh a little testy today are we? Not getting any? Have you checked the error log? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] db messed up
[snip] phpMyAdmin closes when trying to access that db and asks for a login. [/snip] Can you connect to the MySQL server from the command line and see the database? If so your likely problem is a config file issue with phpmyadmin? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php