Navicat Import MySQL Library Demo

February 19, 2021 1008 points heat 1 person likes 0 comments

Background: Take the user Wang Mou in the screenshot as an example. In order to avoid backbiting, teach him how to recover data by the way~
For our small personal site, the general backup is to fully export the table structure and data of the database to a sql file. When restoring, the SQL in the sql file can be quickly restored by executing the SQL. Here is a brief description of how to import MySQL backups through Navicat,

First, select the library we want to import (double click, screenshots are for demonstration purposes)

After opening, right click again and select Run SQL File

In the open window, select the SQL file to be executed and click Start

Wait until the execution is completed

Prompt [SQL] Finished successfully after success


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

Article comments