This is how I do it:
Old server:
cd /var/lib/mysql tar -zcvf filename.tgz databasename
New server:
cd /var/lib/mysql scp serverx.serverdomain.com:/var/lib/mysql/filename.tgz ./
[ enter password ]
tar -zxvf filename.tgz
Done.
This is how I do it:
Old server:
cd /var/lib/mysql tar -zcvf filename.tgz databasename
New server:
cd /var/lib/mysql scp serverx.serverdomain.com:/var/lib/mysql/filename.tgz ./
[ enter password ]
tar -zxvf filename.tgz
Done.