how would you do a mysql backup to another server over ssh?

This is what I tried and I lost the mysql connection:

mysqldump -A -h11.111.111.111 -P22 -uroot -p > testingadump.sql;

It did not work.

Any clues?

Aaron

Is that supposed to work?

I would do it this way:

mysqldump -uroot -ppassword database | ssh username@11.111.111.111 'cat > testingdump.sql'

I dunno if it's supposed to work or not. I was just trying to logically figure it out. Yours 'appears' to be working <crossing fingers>

Thanks.

Aaron