It might be a permissions problem. Mysql is trying to create a temporary file to do the ALTER but cannot. Check for the write permissions/ownership on the data directory.
Regard, Bhavin. ----- Original Message ----- From: "Nick Stuart" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Wednesday, January 08, 2003 2:15 PM Subject: Alter table error > Got another problem with 4.0.7 when trying to alter the table. > Trying to run: > ALTER TABLE `call_information` CHANGE `close_date` `close_date` > TIMESTAMP DEFAULT '' NOT NULL > and it returns a: > 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?? I think it has something to do with > my case problem that I posted before because if you look it says > helpdesk instead of HelpDesk. > > -- > > -Nick Stuart > > USM Computer Science Major > Visit us at http://csforum.newtsplace.com > (run with LAMP) > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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