Method 1 (Long Method)

mysqldump -u USER -pPASSWORD DATABASE > filename.sql

copy the file to the new host and restore using

mysql -u USER -pPASSWORD DATABASE < filename.sql

Method 2 (short method)

mysqldump –opt –compress –user=USERHERE –password=PWHERE
–host=SOURCE.HOST.HERE SOURCE_DB_NAME | mysql –user=USERHERE
–password=PWHERE –host=TARGET.HOST.HERE -D TARGET_DB_NAME -C
TARGET_DB_NAME