打开数据库，如图
![navicat如何导入sql文件和导出sql文件[图]](https://exp-picture.cdn.bcebos.com/9881b1fce186242fdf2621ac35e434daf15ee8eb.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_640%2Climit_1%2Fformat%2Cf_auto%2Fquality%2Cq_80)
右键数据库，弹出个列表框，如图
![navicat如何导入sql文件和导出sql文件[图]](https://exp-picture.cdn.bcebos.com/19587f20a7cd0c6e7fa6b700fed7997bbaf4ddeb.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_640%2Climit_1%2Fformat%2Cf_auto%2Fquality%2Cq_80)
选择导出sql文件的类型，如图
![navicat如何导入sql文件和导出sql文件[图]](https://exp-picture.cdn.bcebos.com/7496877bbbf4da58f88e6bfaea0f8b56ac04d7eb.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_640%2Climit_1%2Fformat%2Cf_auto%2Fquality%2Cq_80)
选择完类型弹出个窗口，选择文本保存的地址，如图
![navicat如何导入sql文件和导出sql文件[图]](https://exp-picture.cdn.bcebos.com/739bc049610f8b5623509bdb9ce951e10ff8d3eb.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_640%2Climit_1%2Fformat%2Cf_auto%2Fquality%2Cq_80)
点击保存，就进入转储sql文件窗口，点击开始就开始执行，导出sql文件了如图
![navicat如何导入sql文件和导出sql文件[图]](https://exp-picture.cdn.bcebos.com/604e9556ad042e6887bde45285f85856d43dd1eb.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_640%2Climit_1%2Fformat%2Cf_auto%2Fquality%2Cq_80)
方法/步骤2
选择运行sql文件，弹出个窗口，如图
![navicat如何导入sql文件和导出sql文件[图]](https://exp-picture.cdn.bcebos.com/50a010f85856d53d3d706d5a47d2bb665059caeb.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_640%2Climit_1%2Fformat%2Cf_auto%2Fquality%2Cq_80)
点击文件那一栏的按钮，弹出个窗口，选择你要导入的sql文件如图
![navicat如何导入sql文件和导出sql文件[图]](https://exp-picture.cdn.bcebos.com/cd93a566515985408b7eb151b5a23a42a17ac4eb.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_640%2Climit_1%2Fformat%2Cf_auto%2Fquality%2Cq_80)
点击打开进入到运行sql文件页面，如图
![navicat如何导入sql文件和导出sql文件[图]](https://exp-picture.cdn.bcebos.com/3b03be7aa010bc334e6c810892efa25f0d143fe8.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_640%2Climit_1%2Fformat%2Cf_auto%2Fquality%2Cq_80)
标签：文件
赏
本文标题： navicat如何导入sql文件和导出sql文件
版权声明：如果本文导致的版权问题以及内容纠错问题请联系站长。
本站资源仅供个人学习交流，请于下载后24小时内删除，不允许用于商业用途，否则法律问题自行承担。
