1

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?

3
  • 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, 2012 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? Feb 10, 2012 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, 2012 at 8:16

0

You must log in to answer this question.

Browse other questions tagged .