How to realize data Export and Import in MySQL

In this issue, the editor will bring you about how to export and import data in MySQL. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

First of all, I will explain the export of mysql data.

Open the tool heidisql, note the 1 and 2 indicated in the diagram, and enter the ip address of the host at 1 (127.0.0.1 if local). Enter the user name and password of the mysql database at 2, and the other settings are as shown in the figure. Click Open to enter the database management interface.

Enter the management interface shown in the figure. The database can be selected in the first place on the left, and the data information of the selected database is automatically displayed in the upper two places on the right.

On the database where you need to export data, right-click and select Export data script.

Then, select the export format. Generally, the export format is .sql. You can customize the export location. After setting it, click the Export button.

Go to the export directory to view the file test.sql just exported, and open it with notepad++. You can see the creation of the database and table and the insertion of the data. At this point, the export of the database data has been explained.

Here's how to insert existing database data into the database.

1 first notepad++ opens the .sql file, and ctrl+a selects all the data and copies it.

2 Open heidisql, paste the data you just copied at figure 1, click the run button at figure 2, you may generate a warning, click OK, and then press F5 to refresh the list. You can see that the database has been successfully created and the data has been inserted.

At this point, the export and import of database data have been introduced, I believe that the smart you have completely learned

The above is how to achieve data export and import in the MySQL shared by the editor. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.