> 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
