> 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