How will. SQL file data is imported into the MySQL database

First, the debugging environment with CMD to import the data in the. sql file:

Winr key to open cmd input:

Mysql-u root-p
After entering MySQL
Mysql>use DR;
Mysql> Source C:/dr.sql

Note that the DR above is your pre-created folder, created in the MySQL data directory, Dr.sql is the content of the database you downloaded, note that Dr.sql is to be placed in the outermost directory of the disk, otherwise the data cannot be imported.

Second, use the MySQL workbence debugging environment to import data:

Open the MySQL workbence software, select Data import/restore, select Import from Self-contain file, and select the storage path of the Dr.sql files to import the data and the default Target Schema database name Dr, finally click on the start import.

Of course the file format of the CMD Import database and the MySQL workbence format are different, but both have frm files.

How will. SQL file data is imported into the MySQL database