Re: Can't open file ****.ibd (errno: 1)
THis problem is due to overwirte od data ( frm file ) or you try to copy that frm file to old existing data or you reinstalled the mysql server so copy the ibdata1 file from old backup ( in data directory)and paste in new installed mysql server data directory and restart service then all innodb databses will work.
Subject
Views
Written By
Posted
13744
July 12, 2005 05:02PM
5360
July 14, 2005 05:09AM
4983
August 26, 2005 11:07AM
5086
August 27, 2005 11:48AM
4583
September 08, 2005 12:42AM
5458
October 18, 2005 08:31PM
3959
October 19, 2005 10:46AM
3794
October 24, 2005 01:42AM
4245
November 04, 2005 03:11AM
4154
October 19, 2007 01:25AM
4410
October 19, 2005 11:19AM
3927
October 25, 2005 11:33AM
24315
November 04, 2005 10:27AM
Re: Can't open file ****.ibd (errno: 1)
3637
February 02, 2007 08:41AM
4404
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.