I got the solution. I stop the ib* files in MySQL datadir and start the server. Now everything is back to normal. Thanks.
sangprabv sangpr...@gmail.com http://www.petitiononline.com/froyo/ On Oct 12, 2010, at 11:00 PM, Suresh Kuna wrote: > Hey Willy - Install the new binaries and start mysql with new binary as > basedir and see whether innodb has enabled or not. Check the error log why > the innodb is getting disabled, make a copy of it here too. > > On Tue, Oct 12, 2010 at 2:57 PM, Willy Mularto <sangpr...@gmail.com> wrote: > Hi List, > Last night accidentally one of my InnoDB table crash. And cause client can > not connect to MySQL, it always said cannot connect to socket, even the > daemon is launched. I tried to set innodb_force_recovery from 0 to 6 and only > number 3 bring back the connection. After that I dump the data and drop the > table. I recreate it as MyISAM and inject the dumped data. After that I stop > MySQL and remove innodb_force_recovery and restart. And clients start > complaining can not connect. Then I enable innodb_force_recovery again. I > tried to create a new InnoDB table test and MySQL complaint cannot create the > table due to the engine type is not supported. The question is how to solve > this problem? How to bring back InnoDB to my server without reinstall the OS > or MySQL itself? I have also tried to drop the database and remove the data > folder from mysql data dir and recreate the database but still no luck. > Thanks for any help. > > > > sangprabv > sangpr...@gmail.com > http://www.petitiononline.com/froyo/ > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com > > > > > -- > Thanks > Suresh Kuna > MySQL DBA