Can you send the error logs from my and Suresh' solutions, so we can see what the next thing to go wrong is ? :-)
----- Original Message ----- > From: "Suporte Avanutri" <supor...@avanutri.com.br> > To: "Suresh Kuna" <sureshkumar...@gmail.com> > Cc: "Johan De Meersman" <vegiv...@tuxera.be>, "Shafi AHMED" > <shafi.ah...@sifycorp.com>, mysql@lists.mysql.com > Sent: Wednesday, 25 January, 2012 1:33:54 PM > Subject: RES: RES: Force drop table > No good news until now... I’m starting to think that I will not > recover it. > When all these tips doesn’t work, should I presume that my database > is dead? > De: Suresh Kuna [mailto:sureshkumar...@gmail.com] > Enviada em: quarta-feira, 25 de janeiro de 2012 02:10 > Para: Suporte Avanutri > Cc: Johan De Meersman; Shafi AHMED; mysql@lists.mysql.com > Assunto: Re: RES: Force drop table > Enable the option innodb_force_recovery =1 in my.cnf file, restart > the database, ( can try upto 4 depending on the description below > url ) and take the dump of all the innodb tables, remove the ibdata > and data file belongs to innodb and re-import. It should be fine. > http://dev.mysql.com/doc/refman/5.0/en/forcing-innodb-recovery.html > Thanks > Suresh Kuna > 2012/1/24 Suporte Avanutri < supor...@avanutri.com.br > > I've tried this before, but the server stills going down. The first > error is always this: > Couldn't execute 'SELECT /*!40001 SQL_NO_CACHE */* FROM 'usuario': > Lost connection to MySQL server during query (2013) > This is followed by other similar errors: "couldn't execute one > thing", couldn't execute another thing, etc". > I've got the error while trying to execute this: mysqldump -u USER > -pPASS --force --databases DATABASE (and tried --all-databases too). > Thanks in advance for the help, guys. I'm starting to learn this > thing by myself, your help has great value to me. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel