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: Force drop table

2012-01-25 Thread Todd Lyons
On Wed, Jan 25, 2012 at 6:42 AM, Todd Lyons wrote: > For example, I shut down my mysql daemon, I make a copy of my > corrupted database at /var/lib/mysql/ into /var/lib/mysql_tmp/, and > then manually start the mysql daemon in the foreground with this: > su - mysql -c '/usr/libexec/mysqld --innod

Re: RES: Force drop table

2012-01-25 Thread Todd Lyons
2012/1/24 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) What's likely happening here is that the access

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
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

Re: RES: Force drop table

2012-01-24 Thread Suresh Kuna
ada em: terça-feira, 24 de janeiro de 2012 13:01 > Para: Suporte Avanutri > Cc: Shafi AHMED; mysql@lists.mysql.com > Assunto: Re: RES: Force drop table > > > > - Original Message - > > From: "Suporte Avanutri" > > To: "Shafi AHMED" , mysql@li

RES: RES: Force drop table

2012-01-24 Thread Suporte Avanutri
by myself, your help has great value to me. -Mensagem original- De: Johan De Meersman [mailto:vegiv...@tuxera.be] Enviada em: terça-feira, 24 de janeiro de 2012 13:01 Para: Suporte Avanutri Cc: Shafi AHMED; mysql@lists.mysql.com Assunto: Re: RES: Force drop table - Original Message -

Re: RES: Force drop table

2012-01-24 Thread Johan De Meersman
- Original Message - > From: "Suporte Avanutri" > To: "Shafi AHMED" , mysql@lists.mysql.com > Sent: Tuesday, 24 January, 2012 3:43:36 PM > Subject: RES: Force drop table > > 120124 12:29:28 InnoDB: Error: table `avanutri/obras` does not exist in

RES: Force drop table

2012-01-24 Thread Suporte Avanutri
You can see the error report below: ---error file- 120124 12:23:07 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible hal