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
13776
July 12, 2005 05:02PM
5374
July 14, 2005 05:09AM
4993
August 26, 2005 11:07AM
5102
August 27, 2005 11:48AM
Re: Can't open file ****.ibd (errno: 1)
4595
September 08, 2005 12:42AM
5465
October 18, 2005 08:31PM
3970
October 19, 2005 10:46AM
3804
October 24, 2005 01:42AM
4255
November 04, 2005 03:11AM
4164
October 19, 2007 01:25AM
4424
October 19, 2005 11:19AM
3940
October 25, 2005 11:33AM
24427
November 04, 2005 10:27AM
3648
February 02, 2007 08:41AM
4414
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.