1, open the mysql client Here use navicat, connect to the database, wait until the main page of navicat, double-click on the database connection that needs to be operated.

2, login to the main page of the database, click on the left side of the database connection, open the database, you can see all the databases can be operated.

3, this time there are two databases, the goal is to synchronize all the data of data 1 to database 2, you need to click on the main page.

4, open the Tools menu, select the Database Synchronization menu, the pop-up dialog box for data synchronization, you can select the data source, the target database.

5, select the database source and the database you need to operate, and then select the target database connection, the target database, and then select the table you need to operate, click Start.