Paul, Robert L. Tom wrote: > I applied these to my dbmail 1.1 mysql database..
> alter table messages add index (unique_id); <--Got an ERROR right here > alter table messages add index (status); <-- also here. > > But I got an error on the last two lines from mysql saying they > don't exists! >That shouldn't happen. Those statements are well tested on clean tables >created from the sql/mysql/create_tables* files, both the myisam and >innodb versions. >Sounds like your messages table is seriously warped. Could you send a >schema-dump ? I am new to mysql, how do you do a schema dump? thanks, Robert
