Mysql Can't find messagefile errmsg.sys解决方法
跳到导航
跳到搜索
mysql Can't find messagefile errmsg.sys解决方法
故障来了
mysql 启动不了 ,报错如下 [root@ ~]# /etc/init.d/mysqld start Starting MySQL.. ERROR! The server quit without updating PID file (/usr/local/mysql/data/vultr.guest.pid).
分析处理过程
为了查看深入而不表面的原因 当然是得查看 err log嘛 [root@ ~]# cat /data/mysqld-error.log 171024 03:12:11 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 171024 3:12:11 [ERROR] Can't find messagefile '/usr/local/mysql/share/errmsg.sys' 171024 3:12:11 InnoDB: The InnoDB memory heap is disabled 171024 3:12:11 InnoDB: Mutexes and rw_locks use GCC atomic builtins 171024 3:12:11 InnoDB: Compressed tables use zlib 1.2.3 171024 3:12:11 InnoDB: Initializing buffer pool, size = 16.0M 171024 3:12:11 InnoDB: Completed initialization of buffer pool 171024 3:12:11 InnoDB: highest supported file format is Barracuda. 171024 3:12:11 InnoDB: Waiting for the background threads to start 171024 3:12:12 InnoDB: 1.1.8 started; log sequence number 6183085273 171024 3:12:12 [ERROR] Aborting 171024 3:12:12 InnoDB: Starting shutdown... 171024 3:12:12 InnoDB: Shutdown completed; log sequence number 6183085273 网上查看了很多方法 很多 小伙伴还说是内存问题 哈哈 那为什么以前才512M ram都可以 跑呢 而现在 1G ram不能跑 哈哈 实在没办法 我打算重新编译安装一个新的mysql ,但不和老的同目录的,但是后来试一下 将源码包里面的sql/share/ 复制到 mysql/share 就好 ,回想起来 可能是我上次不小心删除了 share目录