Topic: Can't get MYSQL to start
I have been trying to get MYSQL working again the last 5 hours...:(
Sorry if i'm unclear in this post, i have been working to fix this and to much hours behind the computer..
Ok so here is my story:
i needed a update from Remi for php-mbstrings . But without watching i also updated mysql to Remi version.. (where it was before i guess not a Remi version)
No problem, i don't have anything running on the server now, not any productive sites.
At that moment mysql would NOT start because i got this message (simular):
[ERROR] Error message file '/usr/share/mysql/english/errmsg.sys' had only 472 error messages,
but it should contain at least 630 error messages.
Check that the above file is the right version for this program!
/usr/libexec/mysqld: Unknown error 1146
[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
InnoDB: Started; log sequence number 0 46409
[ERROR] Aborting
I read in a other post:
mysql-libs was the correct version, so the only fix was to overwrite /usr/share/mysql/* with the files from 5.1.33 and manually re-run mysql_install_db.
So i did the following:
yum remove mysql mysql-devel mysql-server
i deleted /usr/share/mysql/
and deleted /var/lib/mysql/
and i also delete etc/my.conf (after different failures)
Than:
yum install mysql mysql-devel mysql-server
Now when i launch MYSQL i get the following error:
Failed to start database :
Initializing MySQL database: Installing MySQL system tables...
110118 7:09:22 [ERROR] Can't find messagefile '/usr/share/mysql/english/errmsg.sys'
110118 7:09:22 [ERROR] Aborting
110118 7:09:22 [Note]
Installation of system tables failed! Examine the logs in
/var/lib/mysql for more information.
You can try to start the mysqld daemon with:
shell> /usr/libexec/mysqld --skip-grant &
and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:
shell> /usr/bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /var/lib/mysql that may be helpful.
Please consult the MySQL manual section
'Problems running mysql_install_db', and the manual section that
describes problems on your OS. Another information source are the
MySQL email archives available at http://lists.mysql.com/.
Please check all of the above before mailing us! And remember, if
you do mail us, you MUST use the /usr/bin/mysqlbug script!
[FAILED]
When i browse to /usr/share/mysql there is no /english/errmsg.sys or no english dir
So logical it does not work.. because that file or files are not there? What am i doing wrong?