MySQL Error 2013: Lost connection to MySQL server during query

错误说明

Navicat For Mysql 在还原数据库时,总是还原失败。仔细看了报的错误, 是这样的一个错误提示:MySQL Error 2013: Lost connection to MySQL server during query。在网上查找了资料,试了几种方法,最后这种方法可行。

解决方法

打开mysql的配置文件 mysql.ini 文件。具体位置看你安装的环境的地址。 当然,如果你使用的是 PHPStudy 套件,如下图就可以打开 mysql.ini 配置文件。phpstudy中mysql.ini位置在 [mysqld] 结点下添加:  max_allowed_packet=500M  。如图所示:mysql配置文件大小然后重启 mysql 服务,再次进行还原就没有问题了。

分享到:更多 ()

8

评论前必须登录!

 

  1. #5

    Hi there colleagues, how is the whole thing, and what you wish for to say regarding this post, in my view its in fact remarkable in favor of me.

    • I’m glad that this article can help you!

      admin5年前 (2015-12-25)
  2. #4

    Hey! Do you know if they make any plugins to safeguard against hackers? I’m kinda paranoid about losing everything I’ve worked hard on. Any tips?

  3. #3

    I love your wordpress theme, where would you download it from?

    matters5年前 (2016-02-25)
  4. #2

    P3NGdN What as up, I wish for to subscribe for this web site to get most up-to-date updates, so where can i do it please help.|

  5. #1

    Really appreciate you sharing this blog post.Really thank you! Much obliged.

    slut roulette5年前 (2016-03-04)