You probably have a permissions issue in your data or temp directory...Mysql is not able to create a temporary table when making the table alteration.
Peter <^_^> --------------------------------------------- Peter Grigor Hoobly Free Classifieds http://www.hoobly.com ----- Original Message ----- From: "Insanely Great" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Saturday, February 15, 2003 12:16 AM Subject: Error No. 7 > Hello > > When I use the Alter table structure command to alter any field, it comes > up with an error > stating that Error number 7 - error in renaming of table "table name.myi" to > "sql-208..." and so on with (Errorcode 13). Thus I am unable to change the > structure of any table. > > I am using MySQL ver 3.23.55 and on a Windows XP professional system. > > Any help. > > Insane > > > > > --------------------------------------------------------------------- > 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