Re: Can't open file ****.ibd (errno: 1)
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.)
Subject
Views
Written By
Posted
13767
July 12, 2005 05:02PM
5370
July 14, 2005 05:09AM
4990
August 26, 2005 11:07AM
5095
August 27, 2005 11:48AM
Re: Can't open file ****.ibd (errno: 1)
4590
September 08, 2005 12:42AM
5461
October 18, 2005 08:31PM
3968
October 19, 2005 10:46AM
3801
October 24, 2005 01:42AM
4251
November 04, 2005 03:11AM
4162
October 19, 2007 01:25AM
4421
October 19, 2005 11:19AM
3936
October 25, 2005 11:33AM
24406
November 04, 2005 10:27AM
3645
February 02, 2007 08:41AM
4410
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.