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

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

Please Do Not Reprint This Article

This article is copyrighted. Please do not reproduce or distribute this article in whole or part, in any form. Links to this article are welcome

Other Related Articles