xxxxxxxxxx
sqlcmd -S SERVERNAME -d MYDATABASE -U USERNAME -P PASSWORD -i C:\path\mysqlfile.sql -o C:\path\results.txt
xxxxxxxxxx
Firstly: Open your MySQL console
//RUN THESE COMMANDS
mysql> use YOUR_DATABASE_NAME
mysql> source FILE_PATH_OF_SQL_FILE
e.g.
mysql> use test
mysql> source c://users.sql
xxxxxxxxxx
- Go to the DB-Connection
- Create a new DB
- Right-Click on this DB,
- Choose Tools > Import. Than choose the .sql-file.