How to import SQL files in Navicat Premium

I started working on my final project today, but this year I used MySQL database, so I used Navicat premium to manage it. The database was written by another friend and needed to be imported, but Navicat did not have a button to directly import SQL files. I tried several times but it didn't work. I checked Baidu, but many of the content was irrelevant. Finally I solved it and wrote down the solution. It turned out to be very simple. . . .

1. First, connect to Navicat, create a new database under the connection, the database name is the same as the one to be imported, select utf-8 as the character set, and confirm

2. First right-click to open the database, then drag the database file directly to the newly created database

3. When this dialog box pops up, just click Start and then complete. Then close the window directly

4. Right click to refresh the database table, then OK

How to solve the error when importing local sql file into Navicat Premium

Create a new database under navicat -> Open database -> Right click to run the sql file. Pay attention to the encoding and database name. Be sure to create a new database with the same name as the database you imported, and the encoding must also be the same. Then importing it again will be fine.
First open the SQL file you want to import and check the encoding format:

So when I created a new database, when choosing the character set, I chose utfmb4, which solved the problem. Nice!

This is the end of this article about how to import SQL files in Navicat Premium. For more information about importing SQL files in Navicat, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope you will support 123WORDPRESS.COM in the future!