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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
