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
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 using mysqldump and rsync.
Keep Reading
Explore more articles and insights
Ork: SSH Server Automation in Go
Read Article
Deno Deploy Killed My Start Page
Read Article