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
13816
July 12, 2005 05:02PM
5378
July 14, 2005 05:09AM
4996
August 26, 2005 11:07AM
5109
August 27, 2005 11:48AM
Re: Can't open file ****.ibd (errno: 1)
4603
September 08, 2005 12:42AM
5469
October 18, 2005 08:31PM
3974
October 19, 2005 10:46AM
3810
October 24, 2005 01:42AM
4259
November 04, 2005 03:11AM
4168
October 19, 2007 01:25AM
4433
October 19, 2005 11:19AM
3944
October 25, 2005 11:33AM
24528
November 04, 2005 10:27AM
3651
February 02, 2007 08:41AM
4420
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.