Mysql DB problem

[saosurya]

Here is the problem. All the db files are deleted automatically from the mysql folder. There are around 100 tables that were created but when we loged in via phpmyadmin , no db';s were shown except of default mysql ones.

NOw I tried to look for files inside ./var/lib/mysql/mysql directory and searched for files with extention .frm,.mdb but there were no files found. Similarly checked the log entry and nothing is found over there,.

What should I do now as the data is very very imp? How can I recover the files ?

Also on the same line the mysql service is stopped , whenever I try to run the services it gives the mysql.socket error,.Earlier it used to connect via --skip-grant-tables but now it doesnt even with that .


Help would be seriously appreciated.

My system runs on fedora 11

[Irithori]

Can you explain that?

All the db files are deleted automatically from the mysql folder.

Which files, in what directory are deleted by what and why?

[saosurya]

Which files: All the databases that were created .

Directory: When ever a db is created it is stored as .frm or .mdb , if i'm not mistaken . And the default location for these storeage is /var/libe/mysql/mysql. Now inside these folders I don;t see any other db files ...

Deleted by what and why ?:--This even I don't know , it just when try to see via phpmyadmin there are no dbs listed nor there are files by these db names inside the folder ..

[Irithori]

Sorry to say, but if you dont have backups, then that´s it.
Data is gone.

[Irithori]

hmm
one thought:
/var/lib/mysql/mysql is the DB for mysql itself (users, permissions, etc)
are there any other directories in /var/lib/mysql?
And do they have files?
If yes, which ones?

ls -la

[elija]

Also check your my.cnf file to see if the db files are being stored in a different directory. Additionally innodb tables will not be stored in the same place they will be stored in a file called innodb1 by default if I remember correctly.

The location will be in the my.cnf file

The phpmyadmin issue may be permissions as you only see databases you have permission to,

[ptkobe]

As elija said, check your my.cnf

Also install
mysql-administrator
and
mysql-query-browser
and check for the files. Just to check, again, as elija pointed, if it is only a phpmyadmin issue.

If in doubt, post your my.cnf and /etc/fstab files.

Regards
Luis