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.
De: Johan De Meersman [mailto:vegivamp@stripped]
Enviada em: terça-feira, 24 de janeiro de 2012 13:01
Para: Suporte Avanutri
Cc: Shafi AHMED; mysql@stripped
Assunto: Re: RES: Force drop table
----- Original Message -----
> From: "Suporte Avanutri" <suporte2@stripped>
> To: "Shafi AHMED" <shafi.ahmed@stripped>, mysql@stripped
> 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
> 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