Tuesday, October 12, 2010

mysql: Error message file '/usr/share/mysql/english

I have upgraded Centos So, Mysql also gets upgraded from latest version to some latest Verion.

 After that when I start the mysql, I got the following error in /var/log/mysqld.log

******************************************************************************
101008 18:43:57 [ERROR] Error message file '/usr/share/mysql/english/errmsg.sys' had only 480 error messages,
but it should contain at least 617 error messages.
Check that the above file is the right version for this program!
101008 18:44:00  InnoDB: Started; log sequence number 6 3148808979
101008 18:44:00 [ERROR] Aborting
...............................
...............................
*******************************************************************************









This was version mismatch error.
For resolvinf this I have check mysql version as
1.)  [root@server2/data5/private/mysql]#rpm -qa |grep -i mysql
mysql-5.0.77-3.el5
MySQL-devel-community-5.1.30-0.rhel5
MySQL-server-community-5.1.30-0.rhel5
MySQL-client-community-5.1.30-0.rhel5
MySQL-shared-community-5.1.30-0.rhel5
[root@server2/data5/private/mysql]#

2.) After that I have downloaded the mysql package from http://downloads.mysql.com/archives/mysql-5.1/mysql-5.1.30.tar.gz

3.) 1) cp /usr/share/mysql/english/errmsg.sys /usr/share/mysql/english/errmsg.sys.backup

4.) extract mysql package and then copy its errmsg.sys to my live mysql as
cp mysql-5.0.86/sql/share/english/errmsg.sys  /usr/share/mysql/english/errmsg.sys



5) mysql_install_db

6) service mysqld start