Using sqlyogent to transfer MySQL database

If your PHP site changed space, it is necessary to transfer the MySQL database, the general transfer method, is a backup and restore, a bit cumbersome, and because the database version of the different will lead to data loss or garbled and so on. Here is a convenient way to introduce the use of sqlyogent to the database transfer. If you don't say more, go straight to the bottom of the list.

The first step is to open sqlyogent, link to the server, read the database information

The second step, click on the shortcut button "SQLyog Database Synchronization Wizard" button, as shown.

In the pop-up window, select "Start a new synchronization session" and click "Next".

The third step, select the transferred data source and target database, the left side of the window is the data source, the right window is the target database, set up and click Next set as shown.

The fourth step, the page will jump to the next window, generally choose the default settings on it, and then click Next, as shown.

The fifth step, this step is to select the table you want to transfer, you can select a table of the transfer, you can transfer the entire database, as long as the need to transfer the table full hook on it, and then click Next, detailed as shown.

Step sixth, this step is to save the project, the default setting is OK, and then the next step, as shown.

The seventh step, this procedure will automatically transfer the database, waiting for transfer, click Next, OK, the entire transfer operation is over, is not very simple AH.