Invisible mysql .frm file
 

Hello everybody,

I am using MYSQL 4/ RHL7.2
I installed mysql and all the files that are required for mysql (frm,myi and myd ) are available there.
After some days Strange thing happened to our server. The mysql server works properly, but no tables found in any databases, even mysql table :confused: When i checked the data directory of mysql frm files are not there!!!!!!!!

This is what i got from our server:

shell# cd /var/lib/mysql/my_database
shell# ls -l users.*
-rwxr-xr-x 1 mysql mysql 6908 Jul 16 19:44 users.MYD
-rwxr-xr-x 1 mysql mysql 3072 Jul 16 19:44 users.MYI

But when i ls -l for users.frm alone it is showing. Does this appear strange?
shell# ls -l users.frm
-rwxr-xr-x 1 mysql mysql 9312 May 22 18:40 users.frm

when u access this thru Mysql admin, i can' see any tables showing.

mysql> show tables;
Empty set (0.00 sec)

But actually the tables are present which is shown below.

mysql> select count(*) from users;
+----------+
| count(*) |
+----------+
| 78 |
+----------+
1 row in set (0.00 sec)

the datas are there, but i cant view the datas using select statment in the defined format........
whenever you select from a table i am getting 'o rows selected' even if there are datas


I initially thought it is a mysql issue. But it is not, because when i create a plain file called test.frm in my home directory, I just cannot view it. But i can open the file and edit etc...

I guess this is a virus. Any antivirus software available for cleaning this???

Anybody faced a similar situation and got rid of the error.

PLEASE HELP!!!!!!!!