在MySQL和Snow Leopard上反复遇到麻烦-无法锁定./ibdata1，错误:35 [英] having repeated trouble with MySQL and Snow Leopard - Unable to lock ./ibdata1, error: 35

问题描述

我对服务器维护不是很了解，并且正在尝试通过管理自己的Mac来学习.我正在使用MySQL数据库(5.5.9)运行本地Rails应用程序.很长一段时间以来一切都很好，直到我尝试启动一个新的Rails项目.当时，我运行了bundle install，将我的mysql gem从0.2.6更新到了0.3.6.从那时起，或者与之相关联(可能那时候我也安装了RVM)，我无法启动MySQL服务器.我收到以下错误:

I don't know very much about server maintenance and am trying to learn by managing my own Mac. I'm running a local rails application with a MySQL database (5.5.9). All has been well for a long time UNTIL I attempted to start a new rails project. At that time, I ran bundle install, which updated my mysql gem from 0.2.6 to 0.3.6. Ever since then, or I'm associating with that (it may be that I also installed RVM around that time), I can't startup my MySQL server. I get the following error:

Unable to lock ./ibdata1, error: 35

反复.我尝试使用以下方法进行修复:

repeatedly. I've tried fixing with:

mv ibdata1 ibdata1.bak
cp -a ibdata1.bak ibdata1

有效(参考: http://cglreport.zhenhua.info/2008/08/mysql-error-unable-to-lock-ibdata1.html )(我也必须在其他一些文件上进行此操作)，但只能使用一段时间.当我重新启动或定期重新出现问题时.这是怎么回事 ?这似乎对我来说不是一个合理的解决方案.有想法吗?谢谢！

which works (reference: http://cglreport.zhenhua.info/2008/08/mysql-error-unable-to-lock-ibdata1.html) (I have to do it on a few other files too), but it only works for a while. When I restart, or periodically the problem comes back. What's going on ? This doesn't seem to be a reasonable solution to me. Ideas? Thanks!

推荐答案

这听起来很令人信服，就像您已经在运行MySQL服务器的实例，并且您正在尝试窃取其正在使用的数据文件一样.

That sounds pretty convincingly like you already have an instance of your MySQL server running, and you're trying to steal a data file that it's using.

这篇关于在MySQL和Snow Leopard上反复遇到麻烦-无法锁定./ibdata1，错误:35的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！