"Too many columns" error when altering column type to ENUM?

2004-02-13 Thread Andrew Iles
I've seen a number of references to the "Too many columns" error, but I'm encountering something that appears to be different. Basically, I'm trying to change a single column in a table (that has 20 columns) from VARCHAR(255) to ENUM(...) where the enum list contains about 900 entries, each a str

Data corruption following a power failure.

2004-02-13 Thread Andrew Iles
Hi. I've noticed that when a server running MySQL crashes and comes back to life, the MyISAM tables typically need to be repaired to account for the fact that they were not flushed when the server went down. However, I've also noticed that when the database is recovered from a crash, the tables

Repeated table crashes (Errno 145). Why?

2004-02-12 Thread Andrew Iles
Hi, Recently I've been seeing the following kind of error message for several of the MyISAM tables in my database: General error: Can't open file: 'build_packages.MYI'. (errno: 145) Running a simple repair operation on the corrupted table will make MySQL happy again, even though the repair st