Blog
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
Loading blog_post_recommendations...