Hello list,
I come here with a case I can say very strange.
I explain, we have a db server with mysql version 5.5.49 on debian
jessie. Some
days ago, our workflow allowed us to purge a large table from one of our
db
servers. By large I mean a table which had 350GB in size.
To purge that
01, 2013 10:49 AM
To: mysql mailing list
Subject: Can't drop table after crash
We had a power hit and when the server came back we had InnoDB
corruption. (I can't get out to the internet from the system with the
db so can I can't paste the exact text in here). The message was about
log
[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
: DROP TABLE TOOK 39MIN
Hi Michael,
Already using innodb_file_per_table.
Krishna
On Mon, Nov 9, 2009 at 9:39 PM, Michael Dykman mdyk...@gmail.com
wrote:
Under InnoDb, you could use file-per-table which would have
significantly reduced the inter-dependencies.. given the large data
size and heavy
min to drop the table.
Thanks,
Dilipkumar
-Original Message-
From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com]
Sent: Tuesday, November 10, 2009 12:04 AM
To: Michael Dykman
Cc: MySQL
Subject: Re: DROP TABLE TOOK 39MIN
Hi Michael,
Already using
Presumably because you are removing 189 gigabyte of data and 549 gigabyte of
indexes, all of which need to be marked as deleted in your innodb file. I/O
is rather expensive :-)
On MyISAM this would have been close to instantaneous (as you probably
expected), because the datafile is used only for
Under InnoDb, you could use file-per-table which would have
significantly reduced the inter-dependencies.. given the large data
size and heavy I/O you report, it might be a wise way to go.
- michael dykman
On Mon, Nov 9, 2009 at 3:41 AM, Johan De Meersman vegiv...@tuxera.be wrote:
Presumably
Hi Michael,
Already using innodb_file_per_table.
Krishna
On Mon, Nov 9, 2009 at 9:39 PM, Michael Dykman mdyk...@gmail.com wrote:
Under InnoDb, you could use file-per-table which would have
significantly reduced the inter-dependencies.. given the large data
size and heavy I/O you report, it
| |
+---++-++---++--+-+--+-++-+-++---+--++-+
1 row in set (2 min 11.29 sec)
mysql drop table bkp_mtlog;
Query OK, 0 rows affected (39 min 7.39 sec)
Thanks,
Krishna
Hi,
Is there any way to rollback a transaction in MySQL 5.1 that contains
Create, Alter, Drop, table statements.
i.e. is there any way to turn off the feature:
Statements That Cause an Implicit Commit
or even remove some of the default statements that cause a commit.
I tried using
On Mon, Mar 16, 2009 at 10:25 AM, Hatem Nassrat hatem.nass...@gmail.com wrote:
Hi,
Is there any way to rollback a transaction in MySQL 5.1 that contains
Create, Alter, Drop, table statements.
No. Sorry.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
I am finding that
DROP TABLE IF EXISTS mytable;
Works fine if the table exists - but if it doesn't exist I get an error?
Surely it should not error and just not try to drop the table.
Is it me?
this feature to get a quicker startup with -A
Database changed
mysql show tables;
+---+
| Tables_in_lsldatabase |
+---+
| lslstore |
+---+
1 row in set (0.00 sec)
mysql drop table if exists recipes;
Query OK, 0 rows affected
I am getting this problem when I am calling this from within a stored
procedure and from the command line area but from MySQLQueryBrowser
Windows package.
I have tried the DROP TABLE IF EXISTS from the mysql DOS-type command
line and it doesn't error - I do notice that (also in your example
not necessarily endorse content contained within this transmission.
Subject: RE: DROP TABLE IF EXISTS - doesnt??
Date: Fri, 15 Aug 2008 14:50:16 +0100
From: [EMAIL PROTECTED]
To: mysql@lists.mysql.com
I am getting this problem when I am calling this from within a stored
procedure and from the command
Maybe what I am seeing in the Query Browser area is in fact a Warning
message and not an error!!
Ahhh...yes maybe that's it. Just fyi, here is the detail of the warning:
mysql drop table if exists recipes;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql SHOW WARNINGS
On Jun 24, 2008, at 2:57 AM, Gwynne Raskind wrote:
I'm having the issue with CREATE TABLE described by Bug #30513 (http://bugs.mysql.com/bug.php?id=30513
). To summarize, a table which previously existed, and then is
dropped by DROP TABLE IF EXISTS, becomes randomly unable to be
recreated
I'm having the issue with CREATE TABLE described by Bug #30513 (http://bugs.mysql.com/bug.php?id=30513
). To summarize, a table which previously existed, and then is dropped
by DROP TABLE IF EXISTS, becomes randomly unable to be recreated. Here
is my comment on that bug:
Having this same
-
From: Gwynne Raskind [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 24, 2008 2:58 AM
To: mysql@lists.mysql.com
Subject: Problem with CREATE TABLE/DROP TABLE
I'm having the issue with CREATE TABLE described by Bug #30513
(http://bugs.mysql.com/bug.php?id=30513
). To summarize, a table which previously
: Problem with CREATE TABLE/DROP TABLE
I'm having the issue with CREATE TABLE described by Bug #30513
(http://bugs.mysql.com/bug.php?id=30513
). To summarize, a table which previously existed, and then is dropped
by DROP TABLE IF EXISTS, becomes randomly unable to be recreated. Here
is my comment
I'm runnning a script that creates a few tables. I have line that drops the
tables before the creation of the tables just in case they already exist (
such as on a re-creation of the tables ).
mysql is giving me the following error on the drop table when I run the
script the first time -- i.e
they already exist (
such as on a re-creation of the tables ).
mysql is giving me the following error on the drop table when I run the
script the first time -- i.e. when there isn't a table to drop yet.
ERROR 1051 at line 1: Unknown table 'MyTable'
Is there a global db setting that will allow
Try running a flush tables in mysql to make sure that mysqld knows about
all the tables on disk.
xtcsuk wrote:
Running the command:
Drop table if exists table1
complaints of table1 does not exist (Error: 1051).
However, if table1 is swapped with another table, irrespective of its
existence
Guys,
Our production database had a table that was suddently dropped a
mystery. I need to find out if there is a way to find the user account
that performed this function. No one is taking ownership and I need to
know if there is a way to find out.
Thanks in advance
--
MySQL General
Clyde Lewis [EMAIL PROTECTED] wrote on 09/26/2005 02:44:40 PM:
Guys,
Our production database had a table that was suddently dropped a
mystery. I need to find out if there is a way to find the user account
that performed this function. No one is taking ownership and I need to
know if
I did check the binlog and saw that the command ran along with the
timestamp. Is there a way to figure out who ran the command?
[EMAIL PROTECTED] wrote:
Clyde Lewis [EMAIL PROTECTED] wrote on 09/26/2005 02:44:40 PM:
Guys,
Our production database had a table that was suddently dropped a
Running the command:
Drop table if exists table1
complaints of table1 does not exist (Error: 1051).
However, if table1 is swapped with another table, irrespective of its
existence it works just fine.
Running a Show Table command lists table1 as an existing table and
trying to create table1
Hello Artem,
thanks for your answer.
For selective replication I would check startup
options --replicate-do-* and --replicate-wild-*.
I'm using replicate-do-db on the client but the problem is, that the
master sends the sql-statements of ALL databases to the repl-client and
the
in the [mysqld] section of the MySQL
configuration file.
Regards,
Artem
-Original Message-
From: Lutz Maibach [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 27, 2005 9:58 AM
To: mysql Liste
Subject: Re: drop table is written to bin-log, load table is NOT -
why
Hello Artem
Hello,
I'm wondering why on a replication client (MySQL 4.0.23) a drop table
XYZ is written to the mysql binlog while the following load table XYZ
from master is not.
This missing binlog-entry in the first repl. client causes a second
replication client, which is replicating the first client
you may need log-slave-update option on if you have daisy-chain replication.
Regards,
Artem
-Original Message-
From: Lutz Maibach [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 26, 2005 8:24 AM
To: mysql Liste
Subject: drop table is written to bin-log, load table is NOT - why
Hello
I look throught the documentation but could not find what I was looking
for (at least I could read between lines).
I have mysql 4.1.7 on solaris and I have 3 differents databanks (let-s
D1, D2, D3). Each of those databases are a mix of innob and MyIsam.
If by mistake a table is dropped
: Weirdness (or bug) with DROP TABLE
This is the only article in this thread
View: Original Format
Newsgroups: mailing.database.myodbc
Date: 2004-10-06 13:03:59 PST
I am using Mandrake 10, MySQL 4.1.5 from RPM downloaded from
dev.mysql.com.
Look at this session:
$ mysql -u root -p permarn
Enter
' for help. Type '\c' to clear the buffer.
mysql select * from tblinstructivos;
Empty set (0.00 sec)
mysql drop table tblinstructivos;
ERROR 1051 (42S02): Unknown table 'tblinstructivos'
mysql select * from `tblinstructivos`;
Empty set (0.00 sec)
mysql drop table `tblinstructivos`;
ERROR 1051
Egor Egorov wrote:
Bug filled: http://bugs.mysql.com/bug.php?id=5784
Thank you!
Nice, thanks to you too ;-)
regards,
- Markus
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Bug filled: http://bugs.mysql.com/bug.php?id=5784
Thank you!
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
/ /|_/ / // /\ \/
Can you create a test case? I.e. a .sql file which is supposed to drop the
table well but instead fails?
This will help us determine if it's a bug and fix if it is.
Thank you!
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by
Hi,
Egor Egorov wrote:
Can you create a test case? I.e. a .sql file which is supposed to drop the
table well but instead fails?
This will help us determine if it's a bug and fix if it is.
Thanks, this hit a pretty interesting nail for me: I can dump it, but I can't load
the dump into the
Hi,
Egor Egorov wrote:
Can you create a test case? I.e. a .sql file which is supposed to drop the
table well but instead fails?
Nevermind my last post, I found the workaround to disable foregin_key_checks
during import; interesting.
Here is a small example:
set foreign_key_checks=0;
CREATE
Hi,
I've a problem that I can't drop a certain table, always get back the error unknown
table.
Version: 4.0.21 (Debian Testing)
Table-Type: InnoDB
mysql show tables;
[...]
| produkt_kategorie|
mysql drop table produkt_kategorie;
ERROR 1051: Unknown table 'produkt_kategorie'
The ownerships
I don't know if it is a bug, but I repeated did:
DROP TABLE IF NOT EXISTS company;
Create table company {
...
...
};
create name_idx on company (name(32));
The server hangs at create name_idxthe first couple of them were
really quick.
Any idea?
Thanks a lot!
Haitao
--
MySQL General
I'm reposting this question, the online manual doesn't address that quetion:
http://www.mysql.com/doc/en/DROP_TABLE.html
Yet, it's a question asked by 3 different comments posted on the manaul
page listed above. Also please post a solutons to the manual page the URL
above.
TIA,
David
--
MySQL
page the URL
above.
It's addressed in the manual, but not on the DROP TABLE page, because it
is not a DROP TABLE issue. The issue is: how can you refer to a table
with a name that contains special characters?
The answer is described on the page that discussed legal names:
http://www.mysql.com/doc
Nobody has any ideas on this one?
Jeff
-Original Message-
From: Jeff McKeon
Sent: Friday, July 25, 2003 3:23 PM
To: [EMAIL PROTECTED]
Subject: rights to create table, select, then drop table..
I have a need to get data from the db that requires me to
1) do a select and create a new
int, nume text);
insert into test1 values (1,cico);
select * from test1;
+--+--+
| id | nume |
+--+--+
|1 | cico |
+--+--+
drop table test1;
So it's clearly working.
Therefore I recommend you to do a
select * from mysql.user;
to see if you have other rules that cancel
I have a need to get data from the db that requires me to
1) do a select and create a new table with the results
2) run a query against that new table
3) drop the new table
I have a script on my server that does this using the root account that
has all on *.* for the db. It works fine.
I
Hello
It looks like 'drop table' implicitely does a 'commit', at least when
issued by the mysql commandline utility with mysql 3.23.51. This
happens even if it was a temporary heap table as typically used to
emulate subselects.
I think this should be documented. (Or better yet, not do
Christian,
- Original Message -
From: Christian Jaeger [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, March 27, 2003 1:42 PM
Subject: Innodb transactions and drop table
Hello
It looks like 'drop table' implicitely does a 'commit', at least when
issued
Christian,
It looks like 'drop table' implicitely does a 'commit', at least when
issued by the mysql commandline utility with mysql 3.23.51. This
happens even if it was a temporary heap table as typically used to
emulate subselects.
I think this should be documented. (Or better yet
At 13:22 +0100 3/27/03, Stefan Hinz wrote:
Christian,
It looks like 'drop table' implicitely does a 'commit', at least when
issued by the mysql commandline utility with mysql 3.23.51. This
happens even if it was a temporary heap table as typically used to
emulate subselects.
I think
On Sunday 05 January 2003 16:10, Francesco wrote:
I tried to drop a table with Mysql 4.0.1 alpha nt and I have encountered
the following problem:
ERROR : Error on delete of .'\camcomm.tmpge.MYI'
The problem persists. I don't know the reason of this error.
I ask if a new version of Mysql (the
Hello,
I tried to drop a table with Mysql 4.0.1 alpha nt and I have encountered
the following problem:
ERROR : Error on delete of .'\camcomm.tmpge.MYI'
The problem persists. I don't know the reason of this error.
I ask if a new version of Mysql (the version 4.0.7 i s released) is better.
]
Sent: Sunday, January 05, 2003 3:10 PM
Subject: problem with drop table
Hello,
I tried to drop a table with Mysql 4.0.1 alpha nt and I have
encountered
the following problem:
ERROR : Error on delete of .'\camcomm.tmpge.MYI'
The problem persists. I don't know the reason of this error.
I ask
Hi!
Daniel == Daniel Kasak [EMAIL PROTECTED] writes:
cut
Daniel Would it be possible to add a 'drop table' command when a connection
Daniel which has made a temporary table has been dropped, to make the logs
Daniel match up with what actually happens? Thanks!
The later MySQL 3.23
it be possible to add a 'drop table' command when a connection
which has made a temporary table has been dropped, to make the logs
match up with what actually happens? Thanks!
Dan
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T
Hi,
my name is Alexander and I have the following problem:
I created a table with a buggy script. The name of the table is
dbimport-import.
The script returned an error but the table was created!
Now when I try to drop this table, the parser told me that I have a syntax
error near '-'!
How can
I created a table with a buggy script. The name of the table is
dbimport-import.
drop table `dbimport-import`; # note: inverted quotes
gmax
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
to drop it from the
InnoDB tablespace:
Create an InnoDB table with the same name in
another MySQL database (= directory). Then copy
the .frm file from that directory to your original
directory. The .frm file will make MySQL think
that your table exists, and DROP TABLE succeeds
then.
Below I have
I have tried to install Mysql 3.23.40 again.
The problem also persists using the program directly mysql.exe of the
directory mysql/bin and with an access ODBC performing the same commands.
To the attempt to perform the command DROP TABLE the error it is always
1051.
Thanks
Regards
Subject
an environment issue or Mascom
behavior.
Regards,
Miguel
I will try of to be clearer.
Operating system: WIN98
Version of Mysql 3.23.40
EXE : Mysql-d-max
I create a table of example.
Create table test ( Field1 tinyint not null ) type=BDB
The table is created regularly.
The statement DROP TABLE test
I will try of to be clearer.
Operating system: WIN98
Version of Mysql 3.23.40
EXE : Mysql-d-max
I create a table of example.
Create table test ( Field1 tinyint not null ) type=BDB
The table is created regularly.
The statement DROP TABLE testresponds Error 1051 - Unknown table test
If you create a Berkeley-DB table (es. CREATE TABLE TEST TYPE BDB) is not
possible delete it after.
The command DELETE TABLE TEST responds Table unknown.
Thank You
Luciano
-
Before posting, please check:
Luciano Pulvirenti writes:
If you create a Berkeley-DB table (es. CREATE TABLE TEST TYPE BDB) is not
possible delete it after.
The command DELETE TABLE TEST responds Table unknown.
Thank You
Luciano
Your CREATE statement is a bit dubious, so check that there is such a
table at all.
--
statements I can create table well. But when I use sql statement
DROP TABLE, I get error: Error on delete of 'xxx.MYI' (Errcode:13). Note,
that things works well if I'm connected from Win2000 to MySQL server that
runs on Linux, trought the same MyODBC driver (2.50.37), with the same ODBC
DSN settings! So I
Just one thing I can think of..
Have you got GRANT privileges to drop DB?
Simon
-Original Message-
From: Vili Germic [mailto:[EMAIL PROTECTED]]
Sent: 31 May 2001 11:37
To: [EMAIL PROTECTED]
Subject: DROP TABLE problem!
Hello everybody,
MySQL - 3.23.38 Win
MyODBC - 2.50.37
I'm
, using MyODBC(ver.
2.50.37) to connect to db trought ODBC. Things works well, except for
dropping table. I'm using ODBC API in MS Visual C++ 6.0 to connect to ODBC.
Trought SQL statements I can create table well. But when I use sql statement
DROP TABLE, I get error: Error on delete of 'xxx.MYI
Hi,
I am facing the following problem with MySQL3.2.3:
OS:Windows NT 4.0
When ever I try to DROP A TABLE it gives the following
"Error on delete of '.\dbhub\data_source_type.MYI'
(Errcode: 13)"
Can someone let me know the reason.It works fine
sometimes.But the behaviour is not consistent.
80 matches
Mail list logo