mysqldump question

[Amit M Bhosle]

Hi:

 i was wondering if there's any way to limit the bandwidth used by
mysqldump to dump data from remote hosts. since i couldn't find any
documentation on this, i assume that mysqldump will use all the
available bandwidth of the network.

 the issue is that i'm looking to fetch data to the tune of 100s of
MBs, and i don't want the mysqldump to hog all the bandwidth, thus
adversely affecting other communication.

thx in advance for ur time.
AB

-- 
A great idea need not be complicated.
http://www.cs.ucsb.edu/~bhosle

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysqldump feature request

[Amit M Bhosle]

Hi:

 I am using mysql 4.1.10 for a while now, and i was wondering how
painful it would be to tweak the mysqldump to support an additional
option, --insert-ignore , which instructs it to create the dump files
with

INSERT IGNORE blah blah
instead of just 
INSERT blah blah

i have actually modified a 4.1.10 nightly build src i had downloaded a
while back, and the changes are very minimal.. few lines at the most..
pretty much the same as that required for the "insert delayed" option.

as of now, everytime i want to migrate to a new mysql version, i need
to get hold of the source, and make these minor changes. hence my
request for the same.

would be great if anyone could point out the possibility of this being
supported in the near future.

thx a ton..
AB



-- 
A great idea need not be complicated.
http://www.i-5.blogspot.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]