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