> 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