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 h
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 like http
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 a
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 sure
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 log
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
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 r
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. J
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
\.err?
Cheers
How about in c:\Program Files\MySQL\MySQL Server 5.0\data\.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 currentl
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
in
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 accura
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 da
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 :)
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 b
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 i
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-
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
>
hert
Cc: [EMAIL 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 form
uot;UNLOCK
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
Sorr
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:
>
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 reac
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. Whe
> in which table i set to use Charset (UTF-8).
> But When i use "mysql>mysqldump -u myname -p mypwd telbook>book.txt", all
> string of table friend's c_name will become "?".
Have you tried:
mysqldump --default-character-set=utf8 -u myname -p mypwd telbook>book.txt
If that doesn't work, which
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 = lower_c
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: http:
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 he
your answer
>Okan
>
>
>2 rows in set (0.00 sec)
>
>- Original Message -
>From: "Paul DuBois" <[EMAIL PROTECTED]>
>To: "Okan CIMEN" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Saturday, March 30, 2002 4:42 PM
>Subject: Re: mys
uBois" <[EMAIL PROTECTED]>
To: "Okan CIMEN" <[EMAIL PROTECTED]>; <[EMAIL 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
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
: [EMAIL PROTECTED]
Sent: 12/1/2001 6:35 AM
Subject: RE: mysqldump: problem/question
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 re
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
> pl
,
--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
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 wi
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
pr
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 Köhntopp" <[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 y
[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 Köhntopp, NetUSE AG Siemenswall, D-24107 Kiel
Tel: +49 431 386 436 00, Fax: +49 431 386 435 99
-
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 chan
This seems to be a competability feater, so you can load it into db2,
oracle etc.
"Kristian Köhntopp" <[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 p
Kristian Köhntopp 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
41 matches
Mail list logo
