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
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 accurate backup.
I have tried both MySQL
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 :)
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 data folder and then making a
b
I've resolved my problem with mysqldump. I read the error message yet again
and it suddenly dawned on me what the problem might be. I made a slight
modification in my table name and, sure enough, the problem went away.
The problem lay in the fact that my table name was References. That's right,
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
>
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 Souza
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
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?
Regards For all
Carlos J Souza
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
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
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 about 4Gbytes. I wonder if there
is a size limit to the database
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
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. When I
did a
> 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
I have a table
create table friend(
f_code int(7) not null AUTO_INCREMENT,
c_name varchar(20), //Use to store Chinese Name
e_name varchar(50) //use to store English Name
);
in which table i set to use Charset (UTF-8).
But When i use "mysql>mysqldump -u myname -p mypwd telbook>book.txt", all strin
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
Hello Members
I am using mysql 3.23.37 on NT.
I am getting problem when i am using mysqldump on NT, dumpfile contains all
table name in lowercase(i was having all tables name in uppercase).
Now i added
[mysqldump]
set-variable = lower_case_table_names= 0
in my.cnf file.(I searched the mail archive
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
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:
H:\>c:\mysql\bin\mysqldump -T "c:\mysql\batch\dump\new_dump" -f -l -v -u
: [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
Another newbie question:
I'm trying to do a mysqldump of a fairly large, wide (two longblobs) table,
and am running into memory problems.
After running for some time the mysqldump process will die with an "Out of
memory (needed 8164 bytes)" message.
Is there a way to tell mysqldump to not cache
Dump database:
mysqldump -uroot -px -A -a -F -l --opt --quote-names
-rc:/mysql/data/dump.sql
Restore
mysql -uroot -px < c:/mysql/data/dump.sql
I forgot to use --quote-names. -Q doesn't seem to work
/Benny
-
Befor
Hi
The following example gives me a problem.
I create a new database by sending the following SQL commands:
create database dummy
create table `Dummy Table` (`Dummy Time` timestamp(14) NOT NULL)
When i run mysqldump with the parameters shown below
mysqldump -uroot -pxx -A -a -F -l
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]>
I have compiled 3.23.38 without problems. I ran the test suite and mysqld
passed all 117 tests (I think it was 117). mysql client works fine but I
tried to use mysqldump and received a core dump (segmentation violation). I
also receive this if I try and run mysqlshow. As far as I can tell,
everyth
>Description:
When I try and run mysqldump, I get a core dump.
>How-To-Repeat:
it repeats anytime I try and run mysqldump.
>Fix:
I have not found a fix yet.
>Submitter-Id:
>Originator:Phillip Porch
>Organization:
Phillip P. Porch <[EMAIL PROTECTED]> NIC:PP1573 finger for
ht
"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: my
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
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?
Long version:
kk@lenz ~ $ cat /etc/SuSE-release
SuSE Linux 7.1 (i386)
VERSION = 7.
> > >
> > > Doug Poland wrote:
> > > >
> > > > Hi,
> > > >
> > > > I'm having a dickens of a time getting mysqldump to
> > > > work. No matter what I enter, mysqldump says...
> > > >
> > > > /usr/local/mysql/bin/mysqldump: option `--databases' doesn't allow an
>argument
> > > >
The prob
On Thu, Mar 08, 2001 at 03:33:54PM -0600, Gerald L. Clark wrote:
>
> Well, I am running 3.23.33, and it works for me.
>
I'm working via ssh on an ISP's host. I wonder if there are
permissions that have to be set in order to run mysqldump.
Out of curiosity, I tried it on another ISP running MySQ
Well, I am running 3.23.33, and it works for me.
Doug Poland wrote:
>
> On Thu, Mar 08, 2001 at 03:03:43PM -0600, Gerald L. Clark wrote:
> > mysqldump --databases db1 db2 db3 ...
> >
> > Note, these are complete databases, NOT tables.
> >
> > to try it do:
> >
> > mysqldump --databases mysql
>
On Thu, Mar 08, 2001 at 03:03:43PM -0600, Gerald L. Clark wrote:
> mysqldump --databases db1 db2 db3 ...
>
> Note, these are complete databases, NOT tables.
>
> to try it do:
>
> mysqldump --databases mysql
>
I've tried that. But I tried it again anyway. This is
a screen copy...
admin:~$
mysqldump --databases db1 db2 db3 ...
Note, these are complete databases, NOT tables.
to try it do:
mysqldump --databases mysql
Doug Poland wrote:
>
> Hi,
>
> I'm having a dickens of a time getting mysqldump to
> work. No matter what I enter, mysqldump says...
>
> /usr/local/mys
Hi,
I'm having a dickens of a time getting mysqldump to
work. No matter what I enter, mysqldump says...
/usr/local/mysql/bin/mysqldump: option `--databases' doesn't allow an argument
I've perused the list archives and looked at the manual. It
should work but doesn't. What am I doing
63 matches
Mail list logo
