From: Tom Brown
Date: November 22 2005 12:10pm
Subject: Re: dump to more than 1 file
List-Archive: http://lists.mysql.com/mysql/191998
Message-Id: <43830A9F.5080909@goodtechnology.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


> The output of mysqldump is standard output, not a file.  You can pipe
> it into another program, or redirect the output to a file, but
> mysqldump does not make a file.  Therefore, there is no option in
> mysqldump to make more than 1 file.
> 
> How is your database stored on disk?  The documentation Edwin pointed
> to shows you how to dump individual tables, so dumping each table
> separately might work.  Also, you can pipe your output into a
> compression utility (bzip2 compresses text smaller than gzip).

yes thanks to you both - alas the majority of the data is made up of 
blobs in a single table to the select option around dates might work - 
Also i may try exporting into named pipes or some other such to get the 
data into more than 1 file

its times like this i wish mysqldump behaved more like exp

thanks