mysqldump - Copying table from one SQL server to another SQL server -

mysqldump - Copying table from one SQL server to another SQL server -

actually have huge amount of info in 1 server , need re-create same data(entire) server. have 2 options:

1> create sql dump source server , import dump in destination server.

2> straight re-create tables source server destination server.

now , in problem because either creating dump or direct copying , both take huge amount of time. want know way more feasible , less time consumption. , easiest(feasible) 'copy' command in unix copying source server destination server? , need re-create tables, not procedures database.

thanks, in advance.

for re-create utilize cp or scp (ssh copy). table transaction think table smaller dump can seek compress dump before copying.

but there may problems if re-create table straight if environment different

mysqldump