How to import sql files into navicat

After opening Navicat for MySQL, click the New link. Many unopened databases will appear. Right-click on any database and select "New Database".

A pop-up window will appear, enter the name of the database, write whatever you want, select GBK for the character set, and you don’t need to select the sorting rule.

Related recommendations: "Navicat for mysql graphic tutorial"

The database is now created, and then you need to right-click and select Open Database, so that the database becomes green and available.

Then pull a sql file from your computer to the corresponding database.

Pull the sql file on the computer to the corresponding database, and a pop-up window will appear.

Click Start, close after running, then right-click on the table in the corresponding database to refresh, and the sql file will be successfully imported into Navicat for MySQL.

The above is the detailed content of How to import sql files into navicat. For more information, please follow other related articles on the PHP Chinese website!