这两天安装了AppServ2.5.9之后,发现MySQL无法启动。
在事件查看器应用程序日记里的错误信息:“Can't find messagefile 'G: erver\AppServ\MySQL\share\english\errmsg.sys'”。
查看MySQL配置文件my.ini在[mysqld]段中有:
#Path to installation directory. All paths are usually resolved relative to this.
basedir="G:\server\AppServ/MySQL"
#Path to the database root
datadir="G:\server\AppServ/MySQL/data/"
根据以往的经验,将应用程序从Linux移植到Windows了,文件路径一般都必须修改,比如:Linux下的“/tmp”与“C:\\WINDOWS\temp”。之所以会出现“G:\server”解析成“G:erver”,我想可能是“\s”被格式化了,所以需要改成“G:\\server”,即:
#Path to installation directory. All paths are usually resolved relative to this.
basedir="G:\\server\AppServ/MySQL"
#Path to the database root
datadir="G:\\server\AppServ/MySQL/data/"
修改完了,启动MySQL,一切正常。