How to import mysql in navicat

How to import mysql in navicat?

First open Navicat for MySQL, then right-click and select New Database, the name is the same as the name of the data we want to import

Then click OK After that, we can see the data we just created appear on the left, then right-click and select "Run SQL File" and a box will pop up. Click "..." to select the path where the file is located,

Click start and the file will be imported successfully!

Strictly speaking, Navicat for MySQL actually exports not the database, but the data and structure of all tables in the database. Therefore, if you do not create a corresponding database, but just find any data to import, the result will be that the database has several tables that were just imported.

Related recommendations: "Navicat for mysql graphic tutorial"

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