[CentOS] OFF Topic: mysql installation problem

Ed Morrison wrote:
> This is interesting:
> 
> Locate shows this:
> 
> [root at ftp ~]# locate mysql | less
> <snip>
> 
> 
> But listing the directories will not show the same files:
> 
> [root at ftp ~]# ls -al /var/lib/mysql/mysql
> total 8
> drwx------  2 mysql mysql 4096 Feb 14 11:44 .
> drwxr-xr-x  4 mysql mysql 4096 Dec 24 13:13 ..
> [root at ftp ~]# ls -al /var/lib/mysql/
> total 20
> drwxr-xr-x   4 mysql mysql 4096 Dec 24 13:13 .
> drwxr-xr-x  27 root  root  4096 Feb 14 11:44 ..
> drwx------   2 mysql mysql 4096 Feb 14 11:44 mysql
> drwx------   2 mysql mysql 4096 Feb 14 11:44 test

reboot and force fsck
touch /forcefsck && shutdown -r now

The only time I have ever experienced files not being where they are 
suppose to be after a fresh install of a package is when the hard drive 
was going south.


also try

rpm --verify

on the various mysql packages