after update mysqld no longer loads correct databases

3 posts / 0 new
Last post
#1 Thu, 03/28/2013 - 12:05
CodeOmegaPrime

after update mysqld no longer loads correct databases

We did an update last night and now we are experiencing a very odd issue.

When mysqld is started using "service mysqld start" or when the server boots up mysql server page in Webmin shows that only information_schema and test databases are available. If I run "killall mysqld" until no mysqld processes are left running, I can then run mysqld_safe --skip-grant-tables & and the databases show up fine. It appears that the system has disassociated the mysql databases stored in /var/lib/mysql/ and I cannot find where it is pulling the others from.

Root is the user that the mysql server is using and the password is correct.

Any help would be appreciated as I do not want to reimage and reinstall everything like I had to do last time. I would prefer to figure out how to fix this as I am tired of reinstalling after every update.

Thanks!

Thu, 03/28/2013 - 15:00
andreychek

Howdy,

Hmm, that's an odd issue!

Did you by chance load a MySQL version from a third party repository?

What you're describing could happen if there was a significant MySQL version change the took place.

If you're using CentOS, what output does this command produce:

rpm -qa | grep -i mysql

Thu, 03/28/2013 - 16:28
CodeOmegaPrime

Returns This

[root@host ~]# rpm -qa | grep -i mysql mysql-server-5.1.67-1.el6_3.x86_64
mysql-libs-5.1.67-1.el6_3.x86_64 MySQL-python-1.2.3-0.3.c1.1.el6.x86_64 dovecot-mysql-2.0.9-5.el6.x86_64 perl-DBD-MySQL-4.013-3.el6.x86_64 mysql-5.1.67-1.el6_3.x86_64 php-mysql-5.3.3-22.el6.x86_64 mysql-connector-odbc-5.1.5r1144-7.el6.x86_64 mysql-devel-5.1.67-1.el6_3.x86_64

Topic locked