No good news until now... Im starting to think that I will not recover it.
When all these tips doesnt 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. -----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 ----- > 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 in the InnoDB internal > InnoDB: data dictionary though MySQL is trying to drop it. > InnoDB: Have you copied the .frm file of the table to the > InnoDB: MySQL database directory from another database? That's a pretty good question it's asking :-) Earlier in your log it mentions that InnoDB wasn't shut down properly - did it crash while you were deleting that table, by any chance? Shut the service down, delete the file <mysqldatadir>/avanutri/obras.frm from disk and restart the service; the table will be gone. There shouldn't be any other files named obras.<something> if all is well. If you can, it is probably also a good idea to make a full dump of all the databases and reinitialize the InnoDB tablespaces - there may still be internal references or pages allocated to that table. Check the online manual for more information on doing that. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql -- Thanks Suresh Kuna MySQL DBA
