In this article I want to show, how to copy database to different host or server in same network using SQLyog. I am using two different server with 10.0.0.10 and  10.0.0.20 IP Address. Step written 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 following two tabs are open, one for 10.0.0.10 another for 10.0.0.20
  5. On 10.0.0.10 tab right click on live database (cgw_3_0_4_test) and click “Copy Database to Different Host/Server”ccc
  6. From Drop down menu select BL-27-Cgw_57_backupbbb
  7. Finally Click Copy button with select structure and dataddd

Thanks for continue with us.

copy database to different host or server MySQLyog

Leave a Reply