Demonstration of Navicat importing MySQL Library

February 19, 2021 440 heat 1 liked it 0 comments

Background of this article: take the user Wang in the screenshot as an example, in order to avoid the back pot, by the way, teach him how to recover the data~
For our small personal site, the general backup is to export the table structure and data of the database to a SQL file. During recovery, the SQL in the SQL file can be recovered quickly. Here is a brief description of how to import MySQL backup through Navicat,

First of all, select the library we want to import (double click, the screenshot is for demonstration)

After opening, right-click again and select 'run SQL file'

In the open window, select the SQL file to execute and click start

Wait for the execution to finish

After success, you will be prompted [SQL] finished successfully


If life is just like the first sight, what is the sad autumn wind painting fan

Article review