Skip navigation links

MySQL Forums :: InnoDB :: Can't open file ****.ibd (errno: 1)


Advanced Search

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
Can't open file ****.ibd (errno: 1) 10640 jchua 07/12/2005 05:02PM
Re: Can't open file ****.ibd (errno: 1) 4238 Marko Mäkelä 07/14/2005 05:09AM
Re: Can't open file ****.ibd (errno: 1) 4137 Americo Vanderlei 08/26/2005 11:07AM
Re: Can't open file ****.ibd (errno: 1) 4276 Maria Modeste 08/27/2005 11:48AM
Re: Can't open file ****.ibd (errno: 1) 3780 Marko Mäkelä 09/08/2005 12:42AM
Re: Can't open file ****.ibd (errno: 1) 4635 Michael Morrissey 10/18/2005 08:31PM
Re: Can't open file ****.ibd (errno: 1) 3205 Chris Bloom 10/19/2005 10:46AM
Re: Can't open file ****.ibd (errno: 1) 2982 Jos Juffermans 10/24/2005 01:42AM
Re: Can't open file ****.ibd (errno: 1) 3372 Christopher TruLove 11/04/2005 03:11AM
Re: Can't open file ****.ibd (errno: 1) 3400 Ionut Petre 10/19/2007 01:25AM
Re: Can't open file ****.ibd (errno: 1) 3235 Heikki Tuuri 10/19/2005 11:19AM
Re: Can't open file ****.ibd (errno: 1) 3207 Heikki Tuuri 10/25/2005 11:33AM
Re: Can't open file ****.ibd (errno: 1) 17098 Heikki Tuuri 11/04/2005 10:27AM
Re: Can't open file ****.ibd (errno: 1) 2863 vijay kadadi 02/02/2007 08:41AM
Re: Can't open file ****.ibd (errno: 1) 3438 anci wasim 01/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.