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
Tuesday, October 12, 2010
Subscribe to:
Posts (Atom)