mysql - ALTER IGNORE ADD INDEX removed in mysql 5.7.4 - What to use instead?
This may help:


Rename the existing table and create a new table.
Use insert ignore to copy data from old table to new table.