In order to do a MySQL dump on a remote machine with ssh, one can do it with the following command:
ssh name@URL 'mysqldump -u root dbname -ppasswd > dbname.sql'
This results in the following Warning:
Warning: Using a password on the command line interface can be insecure
In order to avoid it, add the file
in the remote machine home directory, with the lines
and change its permissions with
chmod 600 ~/.my.cnf
and use the following command instead:
ssh name@URL 'mysqldump -u root dbname > dbname.sql'