Oneliner for migrating mysql databases from one host to another August 23, 2018Uncategorizeda.philippi mysqldump --lock-all-tables -u root --all-databases | ssh remoteuser@remotehost mysql -u root