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
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.