Import Database

Take mysqldump on old server

mysqldump -u root -p example.com > /tmp/example.com.sql

Lets copy and import the MySQL dump on new server

rsync -avz --progress [email protected]:/tmp/example.com.sql /tmp
pv /tmp/example.com.sql | mysql example.com

As of now we have same web-root and database as old server.