Using sqlyogent to transfer MySQL database

Source: Internet
Author: User
Tags mysql window 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.



Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.