Re: Can't open file ****.ibd (errno: 1)
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?
Subject
Views
Written By
Posted
13756
July 12, 2005 05:02PM
5363
July 14, 2005 05:09AM
4986
August 26, 2005 11:07AM
Re: Can't open file ****.ibd (errno: 1)
5088
August 27, 2005 11:48AM
4585
September 08, 2005 12:42AM
5461
October 18, 2005 08:31PM
3963
October 19, 2005 10:46AM
3796
October 24, 2005 01:42AM
4248
November 04, 2005 03:11AM
4157
October 19, 2007 01:25AM
4416
October 19, 2005 11:19AM
3932
October 25, 2005 11:33AM
24355
November 04, 2005 10:27AM
3640
February 02, 2007 08:41AM
4407
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.