进入mysql控制台
$ mysql -u root -p
Enter password: ******
打开xxx数据库
mysql> use xxx(数据库名称);
Database changed
导入.sql文件
mysql> source D:\NoSpace\mybatis_test.sql; # 最好使用全英文路径,中文可能出错
Query OK, 0 rows affected, 1 warning (0.07 sec)
Query OK, 0 rows affected (0.00 sec)
...
Query OK, 0 rows affected (0.00 sec)
结果
mysql> show tables;
+------------------------+
| Tables_in_mybatis_test |
+------------------------+
| batch |
| batchdetail |
| customer |
| finacial_products |
| gameplayer |
| magician_info |
| pro_mapping_usr |
| product |
| user |
| users |
| warrior_info |
+------------------------+