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). -Sheeri On 11/21/05, ISC Edwin Cruz <[EMAIL PROTECTED]> wrote: > Mysqldump has "where" condition, you may have to segment your data and dump > it in diferents files > > Mysqldump .... --where='date between \'dateStart\' and \'dateFinish\' ' (for > example) > > > See full documentation at: > http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html > > > Regards!! > Edwin Cruz > > -----Mensaje original----- > De: Tom Brown [mailto:[EMAIL PROTECTED] > Enviado el: Lunes, 21 de Noviembre de 2005 09:57 a.m. > Para: mysql@lists.mysql.com > Asunto: dump to more than 1 file > > > is it possible to do a mysql dump to more than 1 file? We will shortly > be needing to dump a db that will be in excess of 50gb so will encounter > file size issues > > This is on 4.1.x and rhel 4 > > thanks > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
