Re: Weird error when creating a field
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" 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]
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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Weird error when creating a field
James Sherwood schrieb: 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 # perror 13 Error code 13: Permission denied Sure the own and group os mysql?? Barry -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Weird error when creating a field
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