MySQL Forums
Forum List  »  InnoDB

Re: Can't open file ****.ibd (errno: 1)
Posted by: anci wasim
Date: January 08, 2008 04:13AM

I have solved this problem,
why the problem is comming : i have copied the data of mysql data folder and reinstall the mysql , then again i paste the data folder files into new created data folder , but i was forget to copy
C:\Program Files\MySQL\MySQL Server 4.1\data\ibdata1
then mysql not found any entries related to old created data tables.

Solution: always copy ibdata1 file with your backup,or mysql data folder.
then when you want to paste, first goto control panel ->administrator tasks-> services->
find mysql service, and stop it. then goto mysql folder

C:\Program Files\MySQL\MySQL Server 4.1\data\
and paste "ibdata1" file.
now you start service from the control panel. and access your database with phpmyadmin or any other tool.

enjoy !
Shaikh Wasim
Developer : php/mysql
anciwasm@gmail.com
+919826320559

Options: ReplyQuote


Subject
Views
Written By
Posted
13744
July 12, 2005 05:02PM
24313
November 04, 2005 10:27AM
3637
February 02, 2007 08:41AM
Re: Can't open file ****.ibd (errno: 1)
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.