Try to look for Lost connection error in MySQL manual and it can give
your some hints like
http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html
Dusan
Hartleigh Burton napsal(a):
Hi All,
I have a database which is currently at ~10GB in it's test phase. It
is containing uncompressed
-Original Message-
From: Dušan Pavlica [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 19, 2007 5:08 AM
To: Hartleigh Burton
Cc: MySql
Subject: {Spam?} Re: mysqldump problem with large innodb tables...
Try to look for Lost connection error in MySQL manual and it can give your some
hints
Hi Dusan,
You replied to a forum post of mine on mysql.com yeah? ;)
I have tried adjusting the max_allowed_packet on both the server and
client. Both are set to 1G now (apparently the highest value
accepted) even though each row is no larger than 100M at very most.
I am thinking this may
My backups use mysqldump, but they have always just worked. I would suggest you
try to make a minimal test case that can reproduce the problem and submit it as
a bug report, if possible.
I'm not familiar with the error message off-hand, but the InnoDB manual is large
and complete, so I'm
Hi Hartleigh,
Hartleigh Burton wrote:
Hi All,
I have a database which is currently at ~10GB in it's test phase. It is
containing uncompressed audio and is expected to reach 1.5TB in no time
at all. I am just running some backup tests and I have been having lots
of problems creating an
Hi Baron,
There are no MySQL errors in the event viewer.
On 18/06/2007, at 10:36 AM, Baron Schwartz wrote:
Hi Hartleigh,
Hartleigh Burton wrote:
Hi All,
I have a database which is currently at ~10GB in it's test phase.
It is containing uncompressed audio and is expected to reach 1.5TB
How about in c:\Program Files\MySQL\MySQL Server 5.0\data\hostname.err?
Cheers
Baron
Hartleigh Burton wrote:
Hi Baron,
There are no MySQL errors in the event viewer.
On 18/06/2007, at 10:36 AM, Baron Schwartz wrote:
Hi Hartleigh,
Hartleigh Burton wrote:
Hi All,
I have a database which is
H no there are no new errors in there. Nothing out of the
ordinary thats for sure. Just notifications that MySQL has started
and is accepting connections etc. :|
On 18/06/2007, at 11:06 AM, Baron Schwartz wrote:
How about in c:\Program Files\MySQL\MySQL Server 5.0\data
\hostname.err?
Is there any indication that the mysqldump crash is killing the server and
causing it to restart? For example, ready for connections notifications just
after you try a mysqldump?
Hartleigh Burton wrote:
H no there are no new errors in there. Nothing out of the ordinary
thats for sure.
No there is no indication of that at all. The server service appears
to be in perfect order, does not drop/restart and my other
applications continue to function without any interruption.
It appears as if the mysqldump connection to the server is
interrupted or maybe there is something in
I'm out of ideas right now. I don't actually use mysqldump that much and have
never had this happen. Hopefully someone else on the mailing list can help, or
perhaps you can try #mysql on Freenode IRC.
Baron
Hartleigh Burton wrote:
No there is no indication of that at all. The server service
Ok... this error has just started popping up in my .err log file...
070618 14:31:10 InnoDB: ERROR: the age of the last checkpoint is
237821842,
InnoDB: which exceeds the log group capacity 237813351.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of
On 2006-11-09 VenuGopal Papasani wrote:
hi all,
I have got a problem with mysql and i want to uninstall it and then
re-install it but the problem is how to recover my data.
This seldom solves problems. What problem do you have, maybe we can help
without having you uninstall your server :)
VenuGopal Papasani wrote:
hi all,
I have got a problem with mysql and i want to uninstall it and then
re-install it but the problem is how to recover my data.My mysqldump
command
is not working.Can i have any other procedure to recover my data like
copying the folder of my database from the
On Thursday 18 August 2005 09:34, Carlos J Souza wrote:
Sirs,
When i use mysqldump on Version 4.1.x, all tables had a one record insert
generated in script. When i use mysqldump on a 4.0.x version this problem
dos not occurs.
How to solve it?
That's because extended inserts are on by
Carlos J Souza [EMAIL PROTECTED] wrote on 08/18/2005 03:16:15 PM:
Sirs,
When i use mysqldump on Version 4.1.x, all tables had a one record
insert generated in script. When i use mysqldump on a 4.0.x version
this problem does not occurs.
How to solve it?
Regards For all
Carlos J
Carlos J Souza wrote:
Sirs,
When i use mysqldump on Version 4.1.x, all tables had a one
record insert generated in script. When i use mysqldump on a
4.0.x version this problem does not occurs.
How to solve it?
Not 100% sure what you are looking for, but try using --skip-extended-insert.
I think what you are seeing is called the extended insert format. It's
much faster to process a single large INSERT statement than several
smaller ones. There are two things to remember:
a) if you have a lot of data in your table, an extended insert statement
may become too long to re-read
PROTECTED]
Subject: RE: mysqldump problem
Sorry, I am running MySQL 4.0.17-nt on Windows 2000 Server.
Consider the OS and filesystem as well (wheatever uyou _are_ using; you
didn't tell us).
Quotas? Limits by FS? getrlimit()?
Would this by any chance be dumping to a disk formatted with the FAT32
On Mon, May 24, 2004 at 03:07:17PM +0100, Gilbert Wu wrote:
Hi,
I've been using mysqldump to backup my entire database. Every day, I restore the
whole thing to my test/develop database by piping the large sql generated by
mysqldump. All is well until the file size of the sql file reached
Sorry, I am running MySQL 4.0.17-nt on Windows 2000 Server.
-Original Message-
From: Brian Reichert [mailto:[EMAIL PROTECTED]
Sent: 24 May 2004 15:42
To: Gilbert Wu
Cc: [EMAIL PROTECTED]
Subject: Re: mysqldump problem
On Mon, May 24, 2004 at 03:07:17PM +0100, Gilbert Wu wrote:
Hi
TABLES; in the middle of the insertion block. Hence, the syntax error during
restoration.
Is this a mysqldump bug?
Regards,
Gilbert
-Original Message-
From: Gilbert Wu
Sent: 24 May 2004 17:10
To: Brian Reichert
Cc: [EMAIL PROTECTED]
Subject: RE: mysqldump problem
Sorry, I am running
Joe Adams wrote:
I have a database setup for replication. I used mysqldump --opt db db.dmp
to do the initial backup of the primary database (after doing a flush tables
with read lock in a seperate session).
I checked the dump file, and all drop table create table statements are in
the file.
in which table i set to use Charset (UTF-8).
But When i use mysqlmysqldump -u myname -p mypwd telbookbook.txt, all
string of table friend's c_name will become ?.
Have you tried:
mysqldump --default-character-set=utf8 -u myname -p mypwd telbookbook.txt
If that doesn't work, which version
Damnish,
Wednesday, May 01, 2002, 3:07:52 PM, you wrote:
D I am using mysql 3.23.37 on NT.
D I am getting problem when i am using mysqldump on NT, dumpfile contains all
D table name in lowercase(i was having all tables name in uppercase).
D Now i added
D [mysqldump]
D set-variable =
kaps,
Sunday, March 31, 2002, 9:54:00 AM, you wrote:
k i m fairly new to mySQL. I have to work on already set up live database
k which can be managedwith phpAdmin system.
k Now i was wondering how can i take a backup (dump) of the database with that
k system?
Use mysqldump utility:
At 16:21 +0200 3/30/02, Okan CIMEN wrote:
Hello,
When I try to get the remote dump of a database, I get the table structure
without any failure but it is not able to get the table data. Has anyone of
you came over to this problem before?
Here is what I have tried:
-T requires that you have the
PROTECTED]
Sent: Saturday, March 30, 2002 4:42 PM
Subject: Re: mysqldump problem
At 16:21 +0200 3/30/02, Okan CIMEN wrote:
Hello,
When I try to get the remote dump of a database, I get the table
structure
without any failure but it is not able to get the table data. Has anyone
of
you came over
PROTECTED]
Sent: Saturday, March 30, 2002 4:42 PM
Subject: Re: mysqldump problem
At 16:21 +0200 3/30/02, Okan CIMEN wrote:
Hello,
When I try to get the remote dump of a database, I get the table
structure
without any failure but it is not able to get the table data. Has anyone
of
you
hi guys!!
i m fairly new to mySQL. I have to work on already set up live database
which can be managedwith phpAdmin system.
Now i was wondering how can i take a backup (dump) of the database with that
system?
I have figured out how can i do it if i have to work on mySQL Server
instead.
Any
Weaver, Walt writes:
I knew it. Nobody bothered to read my post.
The original problem involved running a lightweight version of mysqldump in
a simulated nanokernel environment with reduced power resources. The
ultimate result, we hope, is to use it to record Quidditch matches being
played
So what was the problem?
Weaver, Walt wrote:
WW: Okay, I know you guys have been wracking your brains for the last two days
WW: trying to solve my problem of mysqldump running out of memory while dumping
WW: a large table.
WW:
WW: I figured it out, so you can all go on
,
--Walt Weaver
Bozeman, Montana, USA
-Original Message-
From: sherzodR
To: Weaver, Walt
Cc: [EMAIL PROTECTED]
Sent: 11/30/2001 3:14 AM
Subject: re: mysqldump: problem/question
So what was the problem?
Weaver, Walt wrote:
WW: Okay, I know you guys have been wracking your brains
Okay, I know you guys have been wracking your brains for the last two days
trying to solve my problem of mysqldump running out of memory while dumping
a large table.
I figured it out, so you can all go on with your lives.
My copy of Paul DuBois' MySQL book came today and immediately solved my
You need to use the following when you build mysql to use all options.
CC=gcc CXX=gcc ./configure --prefix=/usr/local/mysql --enable-thread-safe-client
--with-berkeley-db=./bdb --with-innodb
Not that CXX is gcc and not the c++ compiler from SCO.
Good Luck,
--
Boyd Gerber [EMAIL PROTECTED]
Kristian Khntopp wrote:
Short version: mysqldump seems to produce a "KEY mid(mid)"
statement, which mysql does not understand. Using
KEY (mid) instead of KEY mid(mid) works, though.
Is this a known problem? Is this an oversight by me?
Ultrashort resolution: kris is stupid and mid is a
This seems to be a competability feater, so you can load it into db2,
oracle etc.
"Kristian Khntopp" [EMAIL PROTECTED]@mail.netuse.de on 03/16/2001 01:06:30 PM
Sent by: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: mysqldump problem?
Short version: mysqldump seems to
It is a known problem, I saw a bug report go through about it a day or so ago.
One workaround I found is to rename the key. I think the problem may have
something to do with the name of the key also being column name or a
special token.
In my case, I had:
int User,
key User(User)
and I
[EMAIL PROTECTED] wrote:
This seems to be a competability feater, so you can load it into db2,
oracle etc.
But not into MySQL - great idea. :-)
Kristian
--
Kristian Khntopp, NetUSE AG Siemenswall, D-24107 Kiel
Tel: +49 431 386 436 00, Fax: +49 431 386 435 99
"Kristian Khntopp" [EMAIL PROTECTED]@mail.netuse.de on 03/16/2001 02:02:28 PM
?Sent by: [EMAIL PROTECTED]
?To: [EMAIL PROTECTED]
?cc: [EMAIL PROTECTED]
?Subject: Re: mysqldump problem?
?
?
?[EMAIL PROTECTED] wrote:
? This seems to be a competability feater, so you can load i
40 matches
Mail list logo