Bug: file permissions problem on ALTER TABLE

2003-01-10 Thread Dirkjan Ochtman
um('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

Re: file permissions problem on ALTER TABLE

2003-01-11 Thread Dirkjan Ochtman
Hi there, I still have problems with this when using MySQL 4.0.8. When I try to DROP a DATABASE, it will go through and delete all the tables, except the last two, apparently because it "can't delete the table.myi file". When I restart the server, I can DROP one of the tables, then I get the error