Check the SQL running file (why is my table imported?)Īfter importing the SQL file, please don't be alarmed if you can't see the tables in your database. When the progress bar reaches 100%, we can click close and run the SQL file OK, as shown in the figure below:Ģ.4.
To open Navicat Premium, we first need to right-click and select New Database, the name is the same as the name of the data we want to import, as shown in the following figure:Īfter clicking OK, we can see the data we just created appear on the left, and then right-click and select "Run SQL File", a box will pop up, click "." to select the path where the file is located, as shown in the following figure:Ĭlick start and import the SQL file we have on the desktop. So, if you don't create a corresponding database, but just find a data to import, the result is just a few more tables just imported in this database. Note : Strictly speaking, what we exported from Navicat Premium above is not the database, but the data and structure of all the tables in the database. If you need to view the SQL file details, we can use a text editing tool to open the SQL file just output, as shown in the following figure:įor the convenience of the demonstration, I first go to my Navicat Premium and delete the database exported from the above demonstration. Open the SQL output file location we just selected, mine is on the desktop, as shown below:ġ.5, view the detailed information of the output file Select the storage location of the exported file and click Save, as shown in the figure below:Ĭheck the dump SQL file interface, check the dump information, when the progress bar reaches 100%, we can click Close, dump the SQL file OK, as shown in the following figure: Select "Dump SQL File"ĭouble-click the database to be exported, right-click the mouse, and select " Dump SQL File ", as shown in the figure below:ġ.2, select the export file storage location Note : Dumping means exporting, and running means importing SQL files.
Save queries in navicat for mysql 12 how to#
Below I will show you how to use Navicat Premium to export and import *.sql data files. For some personal assistant software, choosing MySQL database is a wise choice, and having a good tool is even more effective. It is very convenient whether it is used by developers for practice, small private server game servers, or personal software. Check the SQL running file (why is my table imported?)
You can right-click the model file in Navicat and choose Open Containing Folder.
To look for the path, choose Tools -> Options -> Miscellaneous -> Profiles Save Path/ Profiles Location. ndm file under Profiles Save Path/ Profiles Location. Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for SQL Server, Navicat for SQLite, Navicat for MariaDB, Navicat PremiumĪpply Navicat Version No.: Version 10.0 or above
0 kommentar(er)
