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

RES: RES: Force drop table

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 exec

Re: RES: Force drop table

- 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 the > InnoDB internal > InnoDB: data di

Re: ERROR 1146 (42S02): Table doesn't exist

- Original Message - > From: "Adarsh Sharma" > > 1. Go to data dir : cd /hdd2-1/mysql_data/ > 2. mv abc abc1 Whatever gave you the idea that it's a good plan to start messing with the files of a service whose inner workings you have no clue about? > ERROR 1146 (42S02): Table 'abc1.job_

RES: Force drop table

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

RE: Force drop table

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

Force drop table

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

ERROR 1146 (42S02): Table doesn't exist

Dear all, Today I changed my database name from abc to abc1 by the below commands :- 1. Go to data dir : cd /hdd2-1/mysql_data/ 2. mv abc abc1 But when I go to the mysql prompt & try to use the tables in abc database , below error occurs: ERROR 1146 (42S02): Table 'abc1.job_queue' doesn't ex

Re: Copying data from one to another MySQL sesrver

- Original Message - > From: "bars0.bars0.bars0" > > Hi all! > > I need to copy data (result set from query) from one server to > another. > This will be done once a month (so cron will be involved:), for data > from previous month. > Any ideas how can I achieve this? > > Should I expor

Re: MYD, MYI and TMD files

- Original Message - > From: "kalin m" > > ok. thanks. i thought so. it's been about 8 hrs so far. and the TMD > file is about half the MYD/MYI file. although MYI is about a gig smaller > than the MYD. which one has the TDM to reach in size in order for the > repair to be complete? The M