title: Restore data database from ibd file not working
body: <p><strong>Mysql 5.5</strong> InnoDB is broken. I have only folder mysql with .frm and ibd file.</p>
  
  <p>I found the answer at <a href="https://dba.stackexchange.com/questions/71596/restoring-mysql-tables-from-ibd-frm-and-mysqllogbin-files">https://dba.stackexchange.com/questions/71596/restoring-mysql-tables-from-ibd-frm-and-mysqllogbin-files</a>. After I upgrade Mysql 5.6 and use tutorial at <a href="http://www.chriscalender.com/tag/innodb-error-tablespace-id-in-file/" rel="nofollow noreferrer">http://www.chriscalender.com/tag/innodb-error-tablespace-id-in-file/</a> with <strong>Method #2</strong> but any data on table <strong>wp_posts in database wordpress</strong> is not correct. It break mysql (lost connection) when I <strong>ALTER TABLE wp_posts IMPORT TABLESPACE</strong>. I cannot restore it. Please help me.</p>
  
  <p>That is data one record after I fix (data being cluttered between columns):</p>
  
  <pre><code>************************* 1. row *************************
                     ID: 2
            post_author: 1
              post_date: 0000-00-09 05:24:20
          post_date_gmt: 9272-08-30 08:00:00
           post_content: V??&lt;&lt;iframe style="width: 100%;" src="https://docs.google.com/forms/d/e/1FAIpQLSe1mpUtq1EYSoLzsVJL_gAv8KCR023wO7uyxU0Tgps1UhHjjg/viewform?embedded=true" width="700" height="1000" frameborder="0" marginwidth="0" marginheight="0"&gt;Đang tải...&lt;/i
             post_title: frame&gt;Đăng ký tư
           post_excerpt: 
            post_status:  vấnp
         comment_status: ublish
            ping_status: clos
          post_password: 
              post_name: edopendang-ki-
                to_ping: 
                 pinged: 
          post_modified: 0909-02-09 08:38:31
      post_modified_gmt: 1378-05-31 30:54:42
  post_content_filtered: 
            post_parent: 1922960506717475414
                   guid: ???        http://duhocvaxuatkhau.co
             menu_order: -315670672
              post_type: age_
         post_mime_type: 
          comment_count: -1629109878096134144
  1 row in set (0.00 sec)
  </code></pre>