Mysql Can't find messagefile errmsg.sys解决方法

来自linux中国网wiki
跳到导航 跳到搜索

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目录 

参考