>> 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).
OK seems like i will be using split for this as i can use
mysqldump -e -u user -ppass dbname | split -b 2000m
to get my db in 2 gig file(s)
I can then cat them together to put them back into the db
thanks
