MySQL - kiss goodbye to your data
Planet MySQL had a blog post about some strange behaviour MySQL is showing
Step One: Create a table with a primary key
Step Two: Alter the table to an auto_increment
Step Three: Kiss goodbye to your data
To be fair: There is a solution to this, but personally I think that should be the default, or at least there should be the a warning or error when such a statement is altering your data.