Windows 上的 Mysql InnoDB“错误 32”
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/283661/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Mysql InnoDB "error 32" on Windows
提问by Cédric Girard
since fews days Mysql server on Windows does not success on closing itself. In the mysql error log I find multiple instance of these lines:
因为几天后 Windows 上的 Mysql 服务器无法成功关闭自身。在 mysql 错误日志中，我找到了这些行的多个实例：
InnoDB: Operating system error number 32 in a file operation. InnoDB: The error means that another program is using InnoDB's files. InnoDB: This might be a backup or antivirus software or another instance InnoDB: of MySQL. Please close it to get rid of this error.
InnoDB：文件操作中的操作系统错误号 32。InnoDB：错误意味着另一个程序正在使用 InnoDB 的文件。InnoDB：这可能是备份或防病毒软件或另一个实例 InnoDB：MySQL。请关闭它以消除此错误。
I have plenty of free space, the server is installed for months, the version is 5.1.22-rc-community-log on Windows XP SP3, and I have used only one Windows account to create and execute Mysql service.
我有很多空闲空间，服务器安装了几个月，Windows XP SP3版本是5.1.22-rc-community-log，而且我只用了一个Windows帐户来创建和执行Mysql服务。
Thanks Cedric
谢谢塞德里克
edit : you are both rigth, and ProcessExplorer help me to find another Mysql service with a special name. I kill it and all run fine. Thanks a lot!
编辑：你们都是严格的，ProcessExplorer 帮助我找到另一个具有特殊名称的 Mysql 服务。我杀了它，一切正常。非常感谢！
采纳答案by Greg
If the file is in use by another program then Process Explorercould help you track down which one has it open. I assume you've checked you only have one copy of MySQL running.
如果该文件正被另一个程序使用，那么Process Explorer可以帮助您追踪打开了哪个程序。我假设您已经检查过您只有一份 MySQL 正在运行。
回答by Till
Sounds like a conflict. Make sure to stop the mysqld service and then double-check if it's really not running anymore, then restart the service. Also, when it's back up, make sure to run checks on your tables and see if there is any damage.
听起来像是冲突。确保停止 mysqld 服务，然后仔细检查它是否真的不再运行，然后重新启动该服务。此外，当它备份时，请确保对您的桌子进行检查，看看是否有任何损坏。
My assumption is based on the operating system error codesin the MySQL docs.
我的假设基于MySQL 文档中的操作系统错误代码。
回答by Anadi Kumar
You can follow these steps:
您可以按照以下步骤操作：
- Open TaskManager
- Kill the mysqld.exeprocess.
cd E:\apps\db\mysql-5.5.25-win32\bin- Run:
mysqld --install MySQL - Run:
mysqladmin -u root start
- 打开任务管理器
- 杀死mysqld.exe进程。
cd E:\apps\db\mysql-5.5.25-win32\bin- 跑：
mysqld --install MySQL - 跑：
mysqladmin -u root start
