Copy MySQL from Old Server to New Server


Follow the steps below for very simple and absolutely effective transfer of your database to a new server

ssh server1 
mysqldump --all-databases -uUSER -pPASSWORD | pigz > backup_YYYYMMMDD.sql.gz
rsync backup_YYYYMMDD.sql.gz 104.238.173.22:/

ssh server2
pigz -dc /backup_YYYYMMDD.sql.gz | mysqldump -uUSER -pPASSWORD