First we open Navicat and connect to the local database, select the connection, right-click to open the connection, or double-click directly.
#In the local database we create a new database to store the imported sql file.
Related recommendations: "Navicat for mysql graphic tutorial"
Set encoding and sorting rules.
Then open the newly created database.
Right-click and select "Run SQL File" as shown in the picture:
Then select the data file, as shown in the picture ：
Click "Start" and the software will start importing. Wait for the progress bar to complete, and the code in the picture will appear, indicating that there is no problem and the import is successful.
Refresh the database table display interface on the right to see the imported database table.
The above is the detailed content of How to import a database into navicat. For more information, please follow other related articles on the PHP Chinese website!