Remove duplicate records from table, leaving one copy
Not sure if this would work in mysql since i am a MSSQL-dba but you could add an identity column -> auto_increment.
This would make all rows unique.
Then you could do a group by on duplicate records and select the highest ID for example. This way you will only delete one row. 
Repeat this until no more duplicates.