Unsupported Screen Size: The viewport size is too small for the theme to render properly.

How To Import From .ibd (innodb) File

forums forums SQLyog Sync tools, Migration, Scheduled Backup and Notifications How To Import From .ibd (innodb) File

Tagged: ,

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • #13336
      chirag1974
      Member

      Hi 

       

      I have two files data.frm and data.ibd

       

      Please guide me how to import data using sqlyog

       

      regards

       

      chirag

    • #35253
      peterlaursen
      Participant

      You cannot import such fiiles with any client tools. Only the server can read those. You should NEVER copy such files from the server data folder. They are useless when moved from there. This applies to InnoDB files in particular. MyISAM files can be copied in most cases though it is not recommended.

       

      You will need to connect to the server from where you copied the files and then export/dump the table. The resulting SQL DUMP -file can be imported from SQLyog ‘tools’ menu .. execute SQL script

Viewing 1 reply thread
  • You must be logged in to reply to this topic.