Thanks for the info,
Not sure how this came about as it has been working fine and it is on a
windows system and using the root user.
Any ideas would be much appreciated,
Thanks,
James
----- Original Message -----
From: "Dan Buettner" <[EMAIL PROTECTED]>
To: "James Sherwood" <[EMAIL PROTECTED]>
Cc: "mysqllist" <mysql@lists.mysql.com>
Sent: Monday, June 19, 2006 11:56 AM
Subject: Re: Weird error when creating a field
James, that is a "permission denied" OS error.
When you run an alter table command (adding a field) MySQL builds a new
table alongside the old, then swaps them. Some file move/rename perations
are associated with that.
I would check that the mysql user on your system has full privileges on
the data and database directories and database files.
Dan
James Sherwood wrote:
Hello,
Today we tried to create a new field on a table in one of our databases.
When we tried to save the field we get the error:
Error on rename of "./DBNAME/TABLENAME.MYI" to
"./DBNAME/#SQL2-210-174.MYI" (Errorcode: 13)
Has anyone ever seen this before?
Thanks,
James
__________ NOD32 1.1607 (20060619) Information __________
This message was checked by NOD32 antivirus system.
http://www.eset.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]