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

Okay, so bouncing off my other question this morning, we had one of our team members run "sudo chmod 775 /" by accident. It brought down the entire site..

Once I was able to get in, nginx came up without problems. sshd was fixed with a few changes in permissions.. I was even able to create a new database so at least our site can run, albeit with an empty database..

However, I'm now trying to recover our original database. How can I recover with just ibdata1, log files, and frm files?

share|improve this question
    
Judging from http://dev.mysql.com/doc/refman/5.0/en/innodb-backup.html you just copy them to the right place and start the server, you have all the files you need. If there is a corruption, check the "Forcing InnoDB Recovery" link on that page. – AndreasM Feb 10 '12 at 20:18
    
Actually, it seems the frm files are corrupted somehow.. I don't know why, though.. Can changing the permissions cause corruption somehow? – farleyknight Feb 10 '12 at 23:20
    
With the mentioned command it's doubtful, with 775 as mask and non-recursive (I assume it was recursive). With a different mask some socket communication could have gone wrong or even just writing to the mysql db files. But the database should be recoverable, to the point of the crash/problem. – AndreasM Feb 11 '12 at 8:16

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.