HeidiSQL tool to export and import MySQL data

Sometimes, in order to facilitate the export and import of data into SQL, we can use certain tools to facilitate the transplantation of our team database, which can achieve twice the result with half the effort. Here, I will briefly introduce a tool that can easily export or import MySQL data.

①First, select the database you want to export and right-click: as shown below

②Here you can select and export the contents of a database you want to export.

③ The meaning of each option during the operation

For the parameters of the above options, here is an explanation

No Date: Do not export data, only the data table structure
Delete+Insert（……）： Clear the data table content and insert the exported new content
Insert: insert only new content
Insert Ignore: Ignore errors when inserting data
Repalce: Replace Insert

One big file: Export a SQL file
Diretcoty...: Each table is a separate file, stored in a specific folder
Clipboard: Export to the clipboard
Database: Import into another database
Server: Import to another server

The database(s) and table(s) above have two options, "Drop" and "Create". If checked, the generated SQL statement will contain statements for deleting and creating databases or data tables. Usually we check them.
Here we export the data we want to export by selecting "Output".

④Select the path you want to save and click Export to export the data

Result data exported successfully

2. Now let's explain how to import data. For example, we have a script file called emp.sql. Here we use HeidiSQL to import data.

① Now let me explain the specific operation process

Select the SQL script you want to execute, click Data Import, and everything will be successful.

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.