How to retrive data from .frm files

Discussion in 'Site & Server Administration' started by gopkris2000, Jul 21, 2010.

  1. #1
    Unfortunately our database has been corrupted and still mysql errors while access website. I have checked in /var/lib/mysql/<database> and found only .frm files.
    How to retrive data from .frm files?
     
    gopkris2000, Jul 21, 2010 IP
  2. aquilax

    aquilax Member

    Messages:
    126
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    33
    #2
    The data is located in the .MYD files;
     
    aquilax, Jul 21, 2010 IP
  3. chandan123

    chandan123 Prominent Member

    Messages:
    11,586
    Likes Received:
    578
    Best Answers:
    0
    Trophy Points:
    360
    #3
    one trick u can do is make a db with same name in ur pc and copy those files to the desired folders and look if it shows again.
     
    chandan123, Jul 21, 2010 IP