System environment: Win7 x64
Software preparation: Navicat premium_11.2.7 Simplified Chinese version
Download URL: http://www.cr173.com/soft/419023.html
Now I'll introduce you to MySQL. Use Navicat to export and import data.
1. Export the database:
Open Navicat, right-click on the database we want to export, then click "Dump SQL File" on the shortcut menu that pops up, and select the first "data and Structure" in the submenu item that pops up again.
Then, a Save box will pop up where you choose to save, select a good location, click OK, OK
2. Import the database:
Open Navicat Premium, then right-click to select New database with the same name as the database we want to import.
Click OK, we can see the left side of the database we have just established, and then right-click to select "Run SQL File" will pop up a box, click "..." to select the path of the file,
Click Start, the file will be imported successfully!
At this point, MySQL uses Navicat to export and import the database has been completed! I wish you success!
MySQL uses Navicat to export and import databases