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

Leave a Comment