mysql导入.sql 文件显示mysql has gone away
来源:互联网 发布:js中的offsetleft 编辑:程序博客网 时间:2024/06/12 22:55
原因:
可能是服务连接超时,或者是脚本文件过大。
1.首先找到 C:\ProgramData\MySQL\MySQL Server 5.7下的my.ini文件
ProgramData 文件夹是被隐藏了,在 控制面板 文件夹选项中设置显示隐藏的文件夹,
2.之后my.ini文件中加入 如下几行:
wait_timeout=2880000
interactive_timeout = 2880000
max_allowed_packet = 100M
3.之后重启mysql服务,或者重启电脑!
0 0
- mysql导入.sql 文件显示mysql has gone away
- MySQL server has gone away,Mysql导入大容量SQL文件数据问题
- mysql导入较大sql文件,出现MySQL server has gone away的解决方法
- 导入SQL导致"MySQL server has gone away"的解决方法
- mysql导入sql问题:server has gone away
- sql文件导入时报错2006 – MySQL server has gone away
- navicat导入.sql文件出错 2006 - MySQL server has gone away
- sql文件导入时报错2006 – MySQL server has gone away
- navicat导入sql文件时报错:mysql server has gone away
- mysql导入的时候has gone away
- MySQL has gone away
- mysql has gone away
- mysql has gone away
- mysql导入数据,报错mysql has gone away
- MySQL导入sql脚本错误:2006 - MySQL server has gone away
- MySQL导入sql脚本错误:2006 - MySQL server has gone away
- MySQL导入sql脚本错误:2006 - MySQL server has gone away
- MySQL导入sql脚本错误:2006 - MySQL server has gone away
- lxc-start conf.c setup_dev_console 1486 Read-only file system
- ZOJ17th校赛I题Course Selection System
- IDEA Maven导自建的jar包
- 纯CSS美化单复选框(checkbox、radio)
- Revit如何判断两个Element是否相交
- mysql导入.sql 文件显示mysql has gone away
- android ANR产生原因和解决办法
- 小鑫去爬山
- 浅聊Http之Get与Post
- quick框架之functions详解
- Thrift C++ 服务器和客户端开发实例--学习笔记
- beamer加载动画+gif导出多个png或者jpg图片
- puppetdb 搭建
- c++练习系统 实验二 静态数据成员和静态成员函数应用