Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.