mysql 复制本表数据

-- 创建备份表
CREATE TABLE users_backup LIKE users;

-- 将数据复制到备份表
INSERT INTO users_backup SELECT * FROM users;

START TRANSACTION;
CREATE TABLE users_backup LIKE users;
INSERT INTO users_backup SELECT * FROM users;
COMMIT;

LOCK TABLES users WRITE;
CREATE TABLE users_backup LIKE users;
INSERT INTO users_backup SELECT * FROM users;
UNLOCK TABLES;

CREATE TABLE users_backup LIKE users;

SET @batch_size = 1000;
SET @offset = 0;

REPEAT
    INSERT INTO users_backup SELECT * FROM users LIMIT @batch_size OFFSET @offset;
    SET @offset = @offset + @batch_size;
UNTIL ROW_COUNT() = 0 END REPEAT;

ALTER TABLE users DROP INDEX idx_name;
INSERT INTO users_backup SELECT * FROM users;
ALTER TABLE users ADD INDEX idx_name (column_name);