MySQL Forums
Forum List  »  InnoDB

Re: Can't open file ****.ibd (errno: 1)
Posted by: Marko Mäkelä
Date: September 08, 2005 12:42AM

You cannot simply copy *.ibd files between servers. The files contain some ID numbers that would have to be translated. Also, the redo log (ib_logfile*) contain references to the *.ibd files. It is in the InnoDB long-term plan to allow the copying of "clean" *.ibd files between servers. ("Clean" means that the files will have to be in consistent state, so that crash recovery will not be needed.)

Options: ReplyQuote


Subject
Views
Written By
Posted
13741
July 12, 2005 05:02PM
Re: Can't open file ****.ibd (errno: 1)
4582
September 08, 2005 12:42AM
24312
November 04, 2005 10:27AM
3637
February 02, 2007 08:41AM
4403
January 08, 2008 04:13AM


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.