[CentOS] OFF Topic: mysql installation problem

Thu Feb 14 23:26:13 UTC 2008
Ed Morrison <edward.morrison at gmail.com>

This is interesting:

Locate shows this:

[root at ftp ~]# locate mysql | less
<snip>
/var/lib/mysql
/var/lib/mysql/ib_logfile0
/var/lib/mysql/ibdata1
/var/lib/mysql/vpopmail
/var/lib/mysql/vpopmail/db.opt
/var/lib/mysql/ib_logfile1
/var/lib/mysql/mysql
/var/lib/mysql/mysql/user.frm
/var/lib/mysql/mysql/help_relation.frm
/var/lib/mysql/mysql/time_zone_leap_second.MYD
/var/lib/mysql/mysql/tables_priv.MYD
/var/lib/mysql/mysql/help_relation.MYI
/var/lib/mysql/mysql/db.frm
/var/lib/mysql/mysql/columns_priv.MYD
/var/lib/mysql/mysql/time_zone_transition.frm
/var/lib/mysql/mysql/func.frm
/var/lib/mysql/mysql/time_zone_name.MYD
/var/lib/mysql/mysql/help_keyword.MYI
/var/lib/mysql/mysql/db.MYD
/var/lib/mysql/mysql/help_relation.MYD
/var/lib/mysql/mysql/columns_priv.frm
/var/lib/mysql/mysql/time_zone_leap_second.frm
/var/lib/mysql/mysql/time_zone_transition_type.MYI
/var/lib/mysql/mysql/help_category.frm
/var/lib/mysql/mysql/time_zone.MYI
/var/lib/mysql/mysql/time_zone_transition.MYD
/var/lib/mysql/mysql/time_zone.MYD
/var/lib/mysql/mysql/time_zone_transition.MYI
/var/lib/mysql/mysql/help_topic.MYD
/var/lib/mysql/mysql/host.frm
/var/lib/mysql/mysql/help_topic.frm
/var/lib/mysql/mysql/time_zone_transition_type.frm
/var/lib/mysql/mysql/help_category.MYI
/var/lib/mysql/mysql/time_zone_name.frm
/var/lib/mysql/mysql/host.MYD
/var/lib/mysql/mysql/host.MYI
/var/lib/mysql/mysql/user.MYD
/var/lib/mysql/mysql/func.MYI
/var/lib/mysql/mysql/columns_priv.MYI
/var/lib/mysql/mysql/tables_priv.MYI
/var/lib/mysql/mysql/func.MYD
/var/lib/mysql/mysql/user.MYI
/var/lib/mysql/mysql/help_category.MYD
/var/lib/mysql/mysql/help_keyword.MYD
/var/lib/mysql/mysql/time_zone_name.MYI
/var/lib/mysql/mysql/help_keyword.frm
/var/lib/mysql/mysql/tables_priv.frm
/var/lib/mysql/mysql/time_zone.frm
/var/lib/mysql/mysql/db.MYI
/var/lib/mysql/mysql/help_topic.MYI
/var/lib/mysql/mysql/time_zone_transition_type.MYD
/var/lib/mysql/mysql/time_zone_leap_second.MYI
/var/lib/mysql/test
/var/www/cgi-bin/extlib/Class/PObject/Driver/mysql.pm
/var/run/mysqld


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