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
13741
July 12, 2005 05:02PM
5360
July 14, 2005 05:09AM
4983
August 26, 2005 11:07AM
5086
August 27, 2005 11:48AM
Re: Can't open file ****.ibd (errno: 1)
4582
September 08, 2005 12:42AM
5457
October 18, 2005 08:31PM
3959
October 19, 2005 10:46AM
3793
October 24, 2005 01:42AM
4245
November 04, 2005 03:11AM
4153
October 19, 2007 01:25AM
4410
October 19, 2005 11:19AM
3926
October 25, 2005 11:33AM
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.