Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have 2 version of database backup.

Mysqldump > db_backup.sql


FRM files (tables files)

The db_backup.sql file is corrupted; it is 0 KB. I think I can't help with it anymore.

Now I only have the FRM files. After I copy all the FRM files to my database folder, in phpmyadmin, I got this message: File not found 'users' errno2

Users is one of the important tables; I can't lose it. Is there any way to repair the FRM files? The files are there. Why does it say "File not found"?

share|improve this question
up vote 1 down vote accepted

The .frm files don't contain the data; the .ibd files have the data, if you have innodb_file_per_table in the my.cnf file. If you don't have innodb_file_per_table in the my.cnf file, the data is in the ibdata1 file.

The .frm files are the table format files. They have the information about the columns in the table. If all you have are .frm files, your data is gone.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.