Find the answer to your Linux question:
Results 1 to 7 of 7
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 ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Apr 2005
    Posts
    9

    Mysql DB problem


    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

  2. #2
    Trusted Penguin Irithori's Avatar
    Join Date
    May 2009
    Location
    Munich
    Posts
    3,387
    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?
    You must always face the curtain with a bow.

  3. #3
    Just Joined!
    Join Date
    Apr 2005
    Posts
    9
    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 ..

  4. #4
    Trusted Penguin Irithori's Avatar
    Join Date
    May 2009
    Location
    Munich
    Posts
    3,387
    Sorry to say, but if you dont have backups, then thatīs it.
    Data is gone.
    You must always face the curtain with a bow.

  5. #5
    Trusted Penguin Irithori's Avatar
    Join Date
    May 2009
    Location
    Munich
    Posts
    3,387
    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?
    Code:
    ls -la
    You must always face the curtain with a bow.

  6. #6
    Penguin of trust elija's Avatar
    Join Date
    Jul 2004
    Location
    Either at home or at work or down the pub
    Posts
    3,535
    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,
    What do we want?
    Time machines!

    When do we want 'em?
    Doesn't really matter does it!?


    The Fifth Continent

  7. #7
    Linux User ptkobe's Avatar
    Join Date
    Feb 2008
    Location
    Torres Vedras, PT
    Posts
    276
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •