RES: RES: RES: Force drop table

2012-01-26 Thread Suporte Avanutri
[mailto:vegiv...@tuxera.be] Enviada em: quinta-feira, 26 de janeiro de 2012 14:53 Para: Todd Lyons Cc: MySQL Help; Suporte Avanutri Assunto: Re: RES: RES: Force drop table - Original Message - > From: "Todd Lyons" > > It doesn't matter what you set in innodb_force_recovery

Re: RES: RES: Force drop table

2012-01-26 Thread Johan De Meersman
- Original Message - > From: "Todd Lyons" > > It doesn't matter what you set in innodb_force_recovery. If you do > not have the obras.frm file (which contains the schema definition of > the table), I don't know if you can retrieve the info. Put that file I recommended he delete that f

Re: RES: RES: Force drop table

2012-01-26 Thread Todd Lyons
2012/1/26 Suporte Avanutri : [At this point I deleted the table “obras.frm”. Still trying to dump, crashing every time, and restarting mysqld with a higher “innodb_force_recovery” value at a time] It doesn't matter what you set in innodb_force_recovery. If you do not hav

RES: RES: RES: Force drop table

2012-01-26 Thread Suporte Avanutri
Community Edition (GPL) Mateus Almeida Avanutri & Nutrição Serviços e Informática Ltda ME CNPJ 07.775.666.0001-60 Insc. Estadual 780.532-67 Rua São José , Nº 1304 Triângulo - Três Rios, RJ CEP 25820-150 Tel./fax: 24 2252-2468 ou 24 2252-2197 website: <http://www.avanutri.com.br/> www

Re: RES: RES: Force drop table

2012-01-25 Thread Johan De Meersman
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: S

RES: RES: Force drop table

2012-01-25 Thread Suporte Avanutri
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

RES: RES: Force drop table

2012-01-24 Thread Suporte Avanutri
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 exec