Dirkjan, > I am using MySQL 3.23.54 on Windows XP (with SP1). Today, I encountered a > weird problem: when trying to ALTER a TABLE, MySQL said that it no > permissions to rename the *.myi file for that table.
Last 3.23 I used was 3.23.49, and I didn't have an ALTER TABLE problem, neither on Win98, Win2K, nor Linux. I did have problems like the ones you describe with 4.0.1, 4.0.3 and 4.0.4 under Win98 and Win2K. Using 4.0.7 now und Win98 and Win2K, the ALTER TABLE problems have gone. Reporting this problem to the list, I heard strange advices like "switch lower_case_table_names to 0". I believe it's a MySQL on Win bug with the 4.0.x versions mentioned above, and it might also affect 3.23 version after 3.23.49. My advice is: Update, MySQL 4.0.7 is real funky :) Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Dirkjan Ochtman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, January 10, 2003 7:40 PM Subject: Bug: file permissions problem on ALTER TABLE > > Hi there, > > > > I am using MySQL 3.23.54 on Windows XP (with SP1). Today, I encountered a > > weird problem: when trying to ALTER a TABLE, MySQL said that it no > > permissions to rename the *.myi file for that table. I kept encountering > > this problem (trying to go from VARCHAR(6) to CHAR(6) for an index field), > > but it would only work after I restarted the mysqld-max-nt. Immediately > > after restarting the server, it worked, but then after a few minutes I > tried > > to ALTER another field in the table, and it had the same problem. So I > > restarted the server again, it went through, but the problem persisted. I > > checked the file permissions, but everyone has full control to the files. > > > > The table now looks like this: > > > > CREATE TABLE postcodes ( > > id mediumint(8) unsigned NOT NULL auto_increment, > > postcode char(6) NOT NULL default '', > > plaats smallint(5) unsigned NOT NULL default '0', > > straat mediumint(8) unsigned NOT NULL default '0', > > low mediumint(5) unsigned NOT NULL default '0', > > high mediumint(5) unsigned NOT NULL default '0', > > parity enum('0','1','2') NOT NULL default '2', > > PRIMARY KEY (id), > > KEY postcode (postcode) > > ) TYPE=MyISAM; > > > > It has 570,441 rows. > > > > Is this a bug in MySQL, or am I doing something wrong? I was using > > phpMyAdmin to do the changes, but I don't think that should make any > > difference. > > > > Regards, > > > > Dirkjan Ochtman > > P.S. I really dislike the spam/off-topic bot at [EMAIL PROTECTED] It > doesn't want this email, and that gives me a kind of > we-don't-want-help-even-if you-really-try-to-describe-the-problem kind of > feeling. > > > --------------------------------------------------------------------- > 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
