Sifr

日本語

Home » Study » Detail

MySQL imcomplete error file

If your MySQL server causes [ERROR] Error message file '/usr/share/mysql/english/errmsg.sys' ...

An environment

I got the error :[ERROR] Error message file '/usr/share/mysql/english/errmsg.sys' had only 480 error messages, but it should contain at least 709 error messages.

OSCentOS 5.6
mysqlmysql-5.5.13-1.el5.remi
mysql-servermysql-server-5.5.13-1.el5.remi
Date

How I took the error

Add epel and remi repositories

  1. rpm -ivh http://download.fedora.redhat.com/pub/epel/5/x86_64/epel-release-5-4.noarch.rpm
  2. rpm -ivh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm

Failed to start MySQL-Server

  1. # /etc/init.d/mysqld start
  2. MySQL Deamon failed to start.
  3. starting mysql :[failed]

I found the reason checking the log file through the command -> cat /var/log/mysqld.log

  • ...
  • [ERROR] Error message file '/usr/share/mysql/english/errmsg.sys' had only 480 error messages, but it should contain at least 709 error messages.
  • ...

How to solve

Get a correct error file ( /usr/share/mysql/english/errmsg.sys ) and overwrite then you can start MySQL-Server. The following link might do if you use the same version.

サイドメニュー