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]

Reply via email to