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
This work is licensed under the Creative Commons Attribution noncommercial use 4.0 international license agreement