You can directly copy a database from one host to another host like this: $> mysqldump -u SOURCE_DB_user –password=SOURCE_DB_pass -h SOURCE_DB_HOST SOURCE_DB_name | mysql -u DB_user –password=DB_pass -h DB_host DB_name