Hmm, okay, but isn't the 3.23 supposed to be stable and thus more bugless than a gamma like 4.0.7?
And also, I was wondering when 4 is going to be released as stable. Looking over the changelogs, it shouldn't be too long, right? Zak: thanks for the advice. I got real pissed off about it, since it seems like a real bug. :) But I guess it helps pretty good. Regards, Dirkjan ----- Original Message ----- From: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]> To: "Dirkjan Ochtman" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, January 10, 2003 11:45 PM Subject: Re: file permissions problem on ALTER TABLE > 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