recover databases without the .frm-files

migoo · #1 (**permalink**) 02-02-04, 08:57

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)

omiossec · #2 (**permalink**) 02-15-04, 11:35

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.

migoo · #3 (**permalink**) 02-15-04, 12:47

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

Internet Services

Web Development

Digital Marketing

Consumer Tech