[CentOS] OFF Topic: mysql installation problem

Fri Feb 15 03:18:53 UTC 2008
Jeff Larsen <jlar310 at gmail.com>

On Thu, Feb 14, 2008 at 6:59 PM, Michael A. Peters <mpeters at mac.com> wrote:
> 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.

Uhh... locate is not exactly real time. Depends on updatedb which is
daily by cron if at all. Though it will warn if the database is over 8
days old...