CREATE TABLE copy_users SELECT * FROM users;
ALTER IGNORE TABLE copy_users ADD UNIQUE (name);
DROP TABLE `users`;
RENAME TABLE `users`.`copy_users` TO `users`.`users` ;