Thats what I thought, but wasnt the case. The directory was open to full control by everyone. I did fix the problem though. It turns out this is an issue with windows not letting anyone edit a file that is in use. And when a table is used mysql will cache and hence windows thinks it's in use and will lock it. I just had to do a mysqladmin -u root refresh and I was able to edit the table. God how I've missed windows! blah! Thanks for the pointer though. I ended up finding this solution somewhere through google, can't remember where atm though.
-Nick On Wed, 2003-01-08 at 19:19, Jennifer Goodie wrote: > >ERROR 7: Error on rename of '.\helpdesk\call_information.MYI' to > >'.\helpdesk\#sql2-b90-81.MYI' (Errcode: 13) > > >Any ideas on why I would get this?? > > Errorcode 13 is permission denied or file not found. Either > .\helpdesk\#sql2-b90-81.MYI exists and your mysqld user does not have > permission to overwrite it, or the user does not have write permissions on > the data dir and everything in it. Using perror will help you decode the > errorcodes. > > > SQL,QUERY > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
