310 days ago,
Navicat supports the restoring of databases from SQL files by using the “Execute SQL File” feature. In this tutorial, we will show you how to execute an SQL file with just a few clicks.
You can simply control-click and select the “Execute SQL File” option to execute an SQL file.
You can then choose the SQL file from the file dialog and then click the “Start” button.
Messages will follow to display the success or failure of the process. Finally, close the window when the process is complete. Afterwards you can refresh to see the changes in Navicat.