Using sqlyogent to transfer MySQL database

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall

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 difference will result in 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, open sqlyogent, link to the server, read database information, if you are not familiar with this step of the operation of friends can see here, "MySQL management tool sqlyogent First (PHP database)."

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.

This article for the Wood homepage Design original, reprint please keep the address www.yzmstzsb.com, thank you.