Re: Innodb Table doesn't exist after restoring database
> I have taken a backup (from one PC) and have restored the database from its backup (containing the folder with .frm for the tables, and ibdata1, ib_logfile0,ib_logfile1) in the data folder (..\MySQL\MySQL Server 5.1\data) of another PC.
Not a reliable way to transfer InnoDB databases. use mysqldump, and make sure either that MySQL major versions match or that you walk through upgrades to matching versions.
Subject
Written By
Posted
Re: Innodb Table doesn't exist after restoring database
June 25, 2015 10:55AM
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.