MySQL Import SQL file

From the command prompt to the bin folder in the MySQL file directory, execute the command
Mysql-u root-p DatabaseName < Db.sql
Where root is your MySQL username, DatabaseName is the name of your database, and db.sql you are the file. Note You have to put Db.sql in the Bin folder. Of course, the location of the file can be changed.

Import Database

Common source Commands

Go to MySQL Database console,

such as Mysql-u root-p

Mysql>use Database

Then use the source command, followed by the script file (for example, the. SQL used here)

Mysql>source D:wcnc_db.sql

MySQL Import SQL file