dtyqflrr775518
2013-11-27 17:35
采纳率: 100%
浏览 60
已采纳

easyphp 13.1中的mysql意外结束

After a power cut and being forced to reboot my win7 PC I couldn't use mySQL on EasyPHP-DevServer 13.1 anymore, the message: “Unexpected end of mysql”:

I've found this post.

Tried all answers and found @Jessiiem answer to work. As I cannot comment (not enough privileges), I want to put here a little to-do list, so people can save time, if running into the same problem:

  1. I found the config file here:

    C:\Program Files (x86)\EasyPHP-DevServer-13.1VC11\binaries\conf_files\my.ini
    
  2. and added:

    innodb_force_recovery = 1
    

    after

    # Uncomment the following if you are using InnoDB tables
    
  3. Then restarted Easy PHP (Run as Administrator);

  4. Uncommented the config file as @Jessiiem suggested:

    # innodb_force_recovery = 1
    

图片转代码服务由CSDN问答提供 功能建议

断电后被迫重启我的win7 PC我再也无法在EasyPHP-DevServer 13.1上使用mySQL了 ,消息:“意外结束了mysql”:</ p>

我发现这个发布。</ p>

尝试了所有答案,发现@Jessiiem回答工作。 由于我无法评论(没有足够的权限),我想在这里添加一些待办事项列表,这样人们可以节省时间,如果遇到同样的问题:</ p>

  1. 我在这里找到了配置文件:</ p>

      C:\ Program Files(x86)\ EasyPHP-DevServer-13.1VC11 \ binaries \ conf_files \ my.ini 
      </ code> </ pre> </ li> 
     
  2. 并添加:</ p>

      innodb_force_recovery = 1 
     </ code> </ pre>  
     
     

    </ p>

     #如果您使用的是InnoDB表,请取消注释以下内容
     </ code> </ pre> </ li> 
     
  3. 然后重新启动Easy PHP(以管理员身份运行); </ p> </ li>

  4. 将配置文件取消注释为@Jessiiem建议:</ p>

      #innodb_force_recovery = 1 
     </ code> </ pre> </ li> 
     </ ol> 
     </ div>

1条回答 默认 最新

相关推荐 更多相似问题