Home>Article>Database> How to import local database in navicat

How to import local database in navicat

angryTom
angryTom Original
2019-08-06 13:44:51 13384browse

How to import local database in navicat

How does navicat import the local database? Why can’t I find the import function? Please see the method below.

Recommended tutorial:MySQL introductory video tutorial

1. First, we open the software and connect to the local database. Select the connection, right-click to open the connection, you can also double-click directly

How to import local database in navicat

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

How to import local database in navicat

3. Set encoding and sorting rules

How to import local database in navicat

4. Then open the newly created database

How to import local database in navicat

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

How to import local database in navicat

6. Then select the data file, as shown in the picture

How to import local database in navicat

7. Click "Start" and the software will start importing. Wait for the progress bar to be completed, and the code in the picture will appear to indicate that there is no problem and the import is successful

How to import local database in navicat

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

How to import local database in navicat

The above is the detailed content of How to import local database in 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