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 again for the other table, so then I restart the server again and I can DROP the last table. The problem also persists on ALTERing TABLEs.
Regards, Dirkjan > 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 > > > > 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. --------------------------------------------------------------------- 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