Re: Restore InnoDB data basing on .frm and common ibdata file

[Aftab Khan]

>Can it happen becuase MySQL dosn't see table because only .frm exist?
>mysql> select * from wp_wpshop_ordered;
>ERROR 1146 (42S02): Table 'word.wp_wpshop_ordered' doesn't exist

When copying MySQL database to another host, you should copy everything inside datadir i.e. all files and folders that includes ib*, *.frm, *.ibd files and MySQLs config file (/etc/my.cnf) too.