MySQL Forums
Forum List  »  Newbie

Re: Innodb Table doesn't exist after restoring database
Posted by: Peter Brawley
Date: June 25, 2015 10:55AM

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

Options: ReplyQuote


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.