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 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
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
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
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
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
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
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:
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:
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
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
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
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
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.
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 mysqlmysqldump -u myname -p mypwd telbookbook.txt, all string
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
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
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:
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
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
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
-
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
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: submitter ID
Originator:Phillip Porch
Organization:
Phillip P. Porch [EMAIL PROTECTED] NIC:PP1573 finger for
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,
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]
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 =
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: mysql
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
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 problem was the ~/.my.cnf file. I took
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
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...
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
I've tried
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 MySQL
61 matches
Mail list logo
