mysql dump using particular table copy from one server another | Copy one Server to Another Server in mysql 

Blog AdminJanuary 11, 2018

1. mysqldump.exe is needed

2. Mysql.exe is needed
2. Change user name, password,port and server Ip address
3. Change Database Name.

Example:

Echo off
Echo ***Please Wait DataBase Transfering***
(cd C:\Program Files\MySQL\MySQL Server 5.6\bin && ^
mysqldump -h Sourceip -u username -ppassword sourcedbname tablename | mysql -h destinationip -u username -ppassword Destinationdbname)> transferlog150331.txt  2>&1
Echo ***
Timeout 10