MySQL Forums
Forum List  »  InnoDB

Re: Can't open file ****.ibd (errno: 1)
Posted by: Maria Modeste
Date: August 27, 2005 11:48AM

I have been trying to copy files from one database server to the next. The table default type is InnoDB and I have been receiving the same error. Apparently, this error is new to MySQL users because there is not much information out there on the net on how to solve this problem.

From my research, I saw advice given to someone to use mysqldump --user [username] --password=[password] [databasename]>filename.

Now I am not an expert programmer, but I have been using the dump thingie as follows:
mysqldump --user maria --password=password mydatabase>mysql.dump;

I have been receiving the typical error message:
"You have an error in your SQL syntax.....check the manual....at line 1."

For the life of me, I can't figure out what the error is. Can anyone please shed some light on how to solve the first error message of, " Can't open file ***.ibd (errno:1)"?
If not can you help me to get the dumpfile thing to work?

Options: ReplyQuote


Subject
Views
Written By
Posted
13740
July 12, 2005 05:02PM
Re: Can't open file ****.ibd (errno: 1)
5085
August 27, 2005 11:48AM
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.