Upgrade Mysql from 5.0.92 to 5.5.30 --> in 5.5.30 foreign keys are checked by default, even before a truncate.