Home  >  Article  >  Database  >  How to import a database into navicat

How to import a database into navicat

爱喝马黛茶的安东尼
爱喝马黛茶的安东尼Original
2019-08-12 10:45:0326490browse

How to import a database into navicat

First we open Navicat and connect to the local database, select the connection, right-click to open the connection, or double-click directly.

How to import a database into navicat

#In the local database we create a new database to store the imported sql file.

How to import a database into navicat

Related recommendations: "Navicat for mysql graphic tutorial"

Set encoding and sorting rules.

How to import a database into navicat

Then open the newly created database.

How to import a database into navicat

Right-click and select "Run SQL File" as shown in the picture:

How to import a database into navicat

Then select the data file, as shown in the picture :

How to import a database into navicat

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.

How to import a database into navicat

How to import a database into navicat

Refresh the database table display interface on the right to see the imported database table.

How to import a database into navicat

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn