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 and IP Address. Step written down:

  1. First, Open SQLYog and connect to (Check and verify IP)
  2. Connect to another IP (Check and verify IP)
  3. Create a new database (BL-27-Cgw_57_backup) at where i want to copy form
  4. Make sure following two tabs are open, one for another for
  5. On 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 Comment