How to open sql in navicat

How to open sql in navicat?

Use navicat to import sql files

1. Open navicat, open the connection, right-click the connection name (if you create a new connection, you need to use the IP address of the corresponding database and password, the local address is localhost, the password is the password of your own mysql database), choose to create a new database, the database name must be the same as the name of the file you want to import (this case is for the sql file that is directly exported from the entire database) A sql file. If the table exports the sql file, it should be named after the database. The table name should be the same as the name of the file that needs to be imported (I have not tried the second case personally)).

Recommended: [navicat tutorial]

2. Right-click the built database, select Run SQL file, and in the Select the SQL file to be imported on the page. Then click Start and wait for the import to complete.

3. After the import is completed, click Close. There may not be imported tables in the database at this time. Right-click the database name or Select Refresh and the table should appear. (In the end, I can’t remember exactly which one I right-clicked, click refresh, and it will usually come out after trying it. It works in my personal test). Then I tried again by right-clicking the name of the table and clicking Refresh.

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