Re: dump to more than 1 file

2005-11-22 Thread Gleb Paharenko
Hello. If you have such a big database, may be you should think about --tab option of mysqldump: http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html Tom Brown wrote: > is it possible to do a mysql dump to more than 1 file? We will shortly > be needing to dump a db tha

Re: dump to more than 1 file

2005-11-22 Thread Tom Brown
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 Edwi

Re: dump to more than 1 file

2005-11-22 Thread Tom Brown
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 Edwi

Re: dump to more than 1 file

2005-11-22 Thread Steve Edberg
At 3:56 PM + 11/21/05, Tom Brown wrote: 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 Probably the best approach - knowing nothing about your

Re: dump to more than 1 file

2005-11-21 Thread sheeri kritzer
efman/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 poss

RE: dump to more than 1 file

2005-11-21 Thread ISC Edwin Cruz
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 needin

dump to more than 1 file

2005-11-21 Thread Tom Brown
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