Import entire MySQL databases from command live over SSH tunnel

.my.cnf

[client]
user=root
password=password
host=127.0.0.1
port=3306
[clientremote]
user=remote_username
password=remote_password
host=127.0.0.1
port=3307

config.fish

function download_mysql
  for db in $argv
    mysqldump --defaults-group-suffix=remote --single-transaction -vBC $db | mysql $db
  end
end

tunnel.sh

 #!/bin/sh
 ssh -L 3307:127.0.0.1:3306 remote_database_server_hostname