title: InnoDB Corruption in Xampp
body: <p>I have a backup from two weeks ago that will be a last resort, but the DB files themselves seem fine and it appears it's just the <code>ibdata1</code> file that is having issues. As stated, I'm using Xampp and MySQL crashes right after I start it. Here is the error log: <a href="http://textuploader.com/7vfd" rel="nofollow noreferrer">http://textuploader.com/7vfd</a></p>
  
  <p>I hadn't done anything out of the ordinary; it seemingly just up and stopped working.</p>
  
  <p>I looked up InnoDB recovery, but the solutions I tried required MySQL to be functional, which it isn't due to the corruption. Is there a way to salvage what are presumably intact IBD files with a bad <code>ibdata1</code> file?</p>
  
  <p>Edit: I was aware of using <code>innodb_force_recovery = #</code> and I had tried it...except I had tried it in the wrong <code>my.ini</code>. I had to use the one in the <code>bin</code> folder. It appears to be fixed now.</p>