title: MySQL InnoDB database restore using .frm files and ibdata files
body: <p>Hi mistakenly I have deleted my MySQL database from Windos XP based PC (this database was used to host a Wiki service using Xampp package). Now I am trying to restore the data so that I can atleast retrieve the TEXT entered in the respective table of Mediawiki package.</p>
  
  <p>After deletion I tried to recover the data using Minitool data recovery software and was able to recover the main schema folder containing .frm files, ib_logfile0, ib_logfile1 and ibdata1 (which was stored under C>xampp>mysql>data).</p>
  
  <p>Now I am trying to restore the database so that I can take a SQL dump and use it accordingly. I have consulted some previous suggestions provided by the experts. Below are the links -</p>
  
  <p><a href="http://www.nerdydork.com/restoring-mysql-innodb-files-on-windows.html" rel="nofollow noreferrer">Restoring MySQL InnoDB files on Windows</a></p>
  
  <p><a href="https://stackoverflow.com/questions/115681/mysql-innodb-database-restore">Stackoverflow answers</a></p>
  
  <p>But these did not help me very much, not sure what exactly I am missing from the instructions. At the end I was unable to start MySQL service and it failed with the below errors in log -</p>
  
  <pre><code>120823 12:17:04 [Note] Plugin 'FEDERATED' is disabled.
  120823 12:17:04 InnoDB: The InnoDB memory heap is disabled
  120823 12:17:04 InnoDB: Mutexes and rw_locks use Windows interlocked functions
  120823 12:17:04 InnoDB: Compressed tables use zlib 1.2.3
  120823 12:17:04 InnoDB: Initializing buffer pool, size = 16.0M
  120823 12:17:04 InnoDB: Completed initialization of buffer pool
  120823 12:17:04 InnoDB: highest supported file format is Barracuda.
  InnoDB: No valid checkpoint found.
  InnoDB: If this error appears when you are creating an InnoDB database,
  InnoDB: the problem may be that during an earlier attempt you managed
  InnoDB: to create the InnoDB data files, but log file creation failed.
  InnoDB: If that is the case, please refer to
  InnoDB: http://dev.mysql.com/doc/refman/5.5/en/error-creating-innodb.html
  120823 12:17:04 [ERROR] Plugin 'InnoDB' init function returned error.
  120823 12:17:04 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
  120823 12:17:04 [ERROR] Unknown/unsupported storage engine: InnoDB
  120823 12:17:04 [ERROR] Aborting
  </code></pre>
  
  <p>Any help to recover from this situation will be highly appreciated. I am willing to provide some more data if required. [<code>MySQL Server Version 5.5, xampp-win32-1.8.0-VC9</code>]</p>