1、利用navicat新建数据库,也可采取其他方式。
![](https://iknow-pic.cdn.bcebos.com/d788d43f8794a4c23596a9c100f41bd5ac6e39a6?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、创建数据库,填入数据库名称。
![](https://iknow-pic.cdn.bcebos.com/908fa0ec08fa513d8e622234336d55fbb3fbd914?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、找到mysql的安装文件的bin文件。
![](https://iknow-pic.cdn.bcebos.com/64380cd7912397dd40b0d1ee5782b2b7d1a2870b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、找到所要导入的sql的文件夹。
![](https://iknow-pic.cdn.bcebos.com/ac6eddc451da81cb77dacb275c66d0160924311f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、用win+r或者开始-菜单-运行,输入cmd打开命令行。
![](https://iknow-pic.cdn.bcebos.com/a50f4bfbfbedab646a65052af936afc378311ec0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、输入d:回车,切换到D盘,输入cd +mysql安装路径下bin文件夹位置。
![](https://iknow-pic.cdn.bcebos.com/3b292df5e0fe9925b21c21ba3aa85edf8cb171c3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、输入u 后面代表mysql数据库用户名 p后面是密码 ,“testwei“代表导入的数据库名称,后面就是导入数据库的sql文件。
![](https://iknow-pic.cdn.bcebos.com/10dfa9ec8a136327c34e8bd99f8fa0ec09fac7bd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
8、打开navicat,看到数据库中,已经导入数据,证明,上述操作成功。
![](https://iknow-pic.cdn.bcebos.com/a71ea8d3fd1f4134bd954c942b1f95cad0c85ebd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)