InnoDB Crash

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.


=20
sangprabv
sangprabv@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=3Dgcdmg-mysql-2@m.gmane.o rg

Re: InnoDB Crash

--0016365ee8a8becdf304926d92f4
Content-Type: text/plain; charset=ISO-8859-1

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 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
> sangprabv@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=sureshkumarilu@gmail.com
>
>


--
Thanks
Suresh Kuna
MySQL DBA

--0016365ee8a8becdf304926d92f4--

Re: InnoDB Crash

--Apple-Mail-1--622988380
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset=us-ascii

I got the solution. I stop the ib* files in MySQL datadir and start the =
server. Now everything is back to normal. Thanks.




sangprabv
sangprabv@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.
>=20
> On Tue, Oct 12, 2010 at 2:57 PM, Willy Mularto =
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.
>=20
>=20
>=20
> sangprabv
> sangprabv@gmail.com
> http://www.petitiononline.com/froyo/
>=20
>=20
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =
http://lists.mysql.com/mysql?unsub=3Dsureshkumarilu@gmail.co m
>=20
>=20
>=20
>=20
> --=20
> Thanks
> Suresh Kuna
> MySQL DBA


--Apple-Mail-1--622988380--