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