mysqldump -u test -p mabase | gzip -c | ssh user@host "cat - > /fichier.sql"

or

ssh user@sourcebox "mysqldump -ppassword opensim assets" | mysql -ppass -Dopensim