Manage MySQL database with Navicat 8.0 (Export import data)

HTTP://DXCNS.BLOG.51CTO.COM/1426423/367105 uses navicat for MySQL to export data from MySQL, including database table creation scripts and data
(1) Export of data: Right-click---> Dump SQL file

At this point, the export operation of the data has been completed.

(2) Data import: First create a good database, then the database is empty, then we do data import: Select the database name that needs to import data, right-click > Run Batch Task file

Select the SQL file that we just exported

Okay, here we go.

After the execution is complete, the data is imported

Manage MySQL database with Navicat 8.0 (Export import data)