dump mysql database and import remote in one step

mysqldump --socket=/localsocket --user=localuser --password=locapassword local_database_name | ssh -p remote_ssh_port remote_system_user@remote_host 'mysql remote_database_name'

Ports should be open, mysql permissions granted, etc….

Leave a Reply

Your email address will not be published. Required fields are marked *