How to copy database to different host or server in same network using SQLyog

In this article, I want to show, how to copy databases to different hosts or servers in the same network using SQLyog. I am using two different servers with 10.0.0.10 and  10.0.0.20 IP Addresses. Step wrote down:

1. First, Open SQLYog and connect to 10.0.0.10 (Check and verify IP)
2. Connect to another IP 10.0.0.20 (Check and verify IP)
3. Create a new database (BL-27-Cgw_57_backup) at 10.0.0.20 where I want to copy form 10.0.0.10
4. Make sure the following two tabs are open, one for 10.0.0.10 another for 10.0.0.20
5. On the 10.0.0.10 tab right-click on the live database (cgw_3_0_4_test) and click “Copy Database to Different Host/Server”
6. From the Dropdown menu select BL-27-Cgw_57_backup
7. Finally, Click the Copy button with select structure and data

Thanks for continue with us.

copy database to different host or server MySQLyog

The article was published on November 11, 2016 @ 2:17 AM