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:vegivamp@tuxera.be] Enviada em: ter=C3=A7a-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" <suporte2@avanutri.com.br> > To: "Shafi AHMED" <shafi.ahmed@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
Jan 25
Suporte Avanutri RES: RES: Force drop table
Jan 25, 2012; 10:33
Suporte Avanutri
RES: RES: Force drop table
Jan 25
Johan De Meersman Re: RES: RES: Force drop table
Jan 25, 2012; 14:02
Johan De Meersman
Re: RES: RES: Force drop table
Jan 26
Todd Lyons Re: RES: RES: Force drop table
Jan 26, 2012; 06:50
Todd Lyons
Re: RES: RES: Force drop table
Jan 26
Johan De Meersman Re: RES: RES: Force drop table
Jan 26, 2012; 17:52
Johan De Meersman
Re: RES: RES: Force drop table
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!