Copying MySQL database quickly
From HostThyself
A method to quickly copy MySQL database is to just copy the entire folder/directory that contains the database.
The default folder for MySQL databases is /var/lib/mysql/. Each database is stored as files in a correspondingly name folder. Simply copy the database folder to another server to copy the database.
As with all data manipulation, make backup before making changes.
