Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    2

    Question Unanswered: recover databases without the .frm-files

    Hi!

    The disk on wich the mysql is located is bad and I have changed to a new disk. I now see that there are a lot of .frm-files missing.

    Is there any way to recover the tables from only the .MYD- and .MYI-files.

    I'm using mysql 4.0.16 on a Linux machine (debian)

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    frm file contain only definition of your table and nothings else. SO you can recreate your table by using sql statement used to create them before.
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Feb 2004
    Posts
    2

    Thank you but...

    I knew that. Sorry if I didn't wrote that. What I was looking for was if there was any way to recreate the frm-file from the .MYD and .MYI-files. You see the problem is that I do not have the exact create definition of the tables

    //Migoo

Posting Permissions

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