MySQL Forums
Forum List  »  Data Recovery

Re: Restore InnoDB data basing on .frm and common ibdata file
Posted by: Aftab Khan
Date: August 23, 2012 01:15AM

>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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Restore InnoDB data basing on .frm and common ibdata file
4439
August 23, 2012 01:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.