How to make a remote mysqldump? I know that's it's possible to do a remote mysqldump if I specify --host but is it possible to create the file in the remote server as well?
What about piping a gzipped mysql dump over ssh.