strange problem with mysql databases not showing

hello
i have strange probelm here
i have several mysql databases which currently are not showing
nor via mysql command lines neither in mysql directory

here is information
mysql is mounted as separate partition in

/var/lib/mysql

when i go to that directory and tried to see databses nothing is there

root@AQUILA:/var/lib/mysql# ls -la total 0 root@AQUILA:/var/lib/mysql#

but at the same time as i know some databases name like asterisk
if i try to cd there the directory is there

root@AQUILA:/var/lib/mysql# cd asterisk root@AQUILA:/var/lib/mysql/asterisk# ls AddressBookEmail.frm callout_calls_OLD.MYI DynConf.MYD Modems.MYD raja_ivr_train_schedule.frm sms_send.frm AddressBookEmail.MYD callout_log.frm DynConf.MYI Modems.MYI raja_ivr_train_schedule.MYD sms_send.MYD AddressBookEmail.MYI callout_log.MYD extensions.frm modules.frm raja_ivr_train_schedule.MYI sms_send.MYI AddressBookFAX.frm callout_log.MYI extensions.MYD

also when i use locate command it shows the path

locate admin.frm /var/lib/mysql/asterisk/admin.frm

so what can be wrong ?permissions ? i guess its the same reason why databases are not showing in mysql command line also as follow

mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | +--------------------+ 1 row in set (0.04 sec)

thank you

Originally Posted by dime111 hello i have strange probelm here i have several mysql databases which currently are not showing nor via mysql command lines neither in mysql directory here is information mysql is mounted as separate partition in when i go to that directory and tried to see databses nothing is there but at the same time as i know some databases name like asterisk if i try to cd there the directory is there also when i use locate command it shows the path so what can be wrong ?permissions ? i guess its the same reason why databases are not showing in mysql command line also as follow thank you

Note that locate shows the files seen at a specific point in time.
So it might be that it is still listed while if you would update the database now, it wouldn't find them anymore.

I would suggest a filesystem check as root should be able to see all files.

What does this command show:
ls -ld /var/lib/mysql

mysql is mounted as separate partition in ...

What is the output of the mount command? It might be that you think it's mounted but actually it's not mounted.

Originally Posted by Wim Sturkenboom What is the output of the mount command? It might be that you think it's mounted but actually it's not mounted.

Then it would be strange that he can see the files when using cd to a subdirectory and the filesystem being unmounted.

Originally Posted by deadeyes Then it would be strange that he can see the files when using cd to a subdirectory and the filesystem being unmounted.

You're right, missed that

Originally Posted by Wim Sturkenboom You're right, missed that

That happens to everybody once in a while