[mailto:vegiv...@tuxera.be]
Enviada em: quarta-feira, 25 de janeiro de 2012 11:02
Para: Suporte Avanutri
Cc: Shafi AHMED; mysql@lists.mysql.com; Suresh Kuna
Assunto: Re: RES: RES: Force drop table
Can you send the error logs from my and Suresh' solutions, so we can see what
the next thing
2012/1/26 Suporte Avanutri supor...@avanutri.com.br:
[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
- Original Message -
From: Todd Lyons tly...@ivenue.com
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
[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 tly...@ivenue.com
It doesn't matter what you set in innodb_force_recovery. If you do
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
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
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)
What's likely happening here
On Wed, Jan 25, 2012 at 6:42 AM, Todd Lyons tly...@ivenue.com 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
Hello,
I need to drop a table, but mysql cannot do it. I think the database is
corrupt. Is there some way to force the drop?
Mateus Almeida
Suporte Técnico
Avanutri Nutrição Serviços e Informática Ltda ME
CNPJ 07.775.666.0001-60 Insc. Estadual 780.532-67
Rua Maestro Costa Barros,
Hi, What is the error associated with pls?
Best Rgs,
Shafi AHMED
-Original Message-
From: Suporte Avanutri [mailto:supor...@avanutri.com.br]
Sent: Tuesday, January 24, 2012 6:05 PM
To: mysql@lists.mysql.com
Subject: Force drop table
Hello,
I need to drop a table
...@sifycorp.com]
Enviada em: terça-feira, 24 de janeiro de 2012 10:52
Para: 'Suporte Avanutri'; mysql@lists.mysql.com
Assunto: RE: Force drop table
Hi, What is the error associated with pls?
Best Rgs,
Shafi AHMED
-Original Message-
From: Suporte Avanutri [mailto:supor
- Original Message -
From: Suporte Avanutri supor...@avanutri.com.br
To: Shafi AHMED shafi.ah...@sifycorp.com, 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
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 -
From: Suporte Avanutri supor...@avanutri.com.br
To: Shafi
Assunto: Re: RES: Force drop table
- Original Message -
From: Suporte Avanutri supor...@avanutri.com.br
To: Shafi AHMED shafi.ah...@sifycorp.com, 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
14 matches
Mail list logo