If you're not on prod database, you could do an export, truncate your table, alter your table, and import with ignore=Y

Hope it helps

Cheers

Fabien