MySqldump either compressed or another box

[JoshFink]

Ok.. I'm trying to fit a big mysqldump onto an already full box.

I figure one of two things will work.

1) Compressing it while it's dumping the db (actually now that I think of it, it probably has to be put somewhere before it can be compressed)

2) Saving the file to another box while it's dumping. Is it possible to open up a connection to another box and have the mysqldump just put it there?

Thanks for the help

Josh

[eva2000]

yup to 2nd option

http://www.mysql.com/doc/m/y/mysqldump.html

mysqldump --opt database | mysql --host=remote-host -C database
of course you need to give permissions on the remote-host for your current server to connect to remote-hosts' mysql server

[JoshFink]

Thank You..

Josh

[eva2000]

Originally posted by JoshFink
Thank You..

Josh no probs :D