dedecms gbk转utf8

mysqldump -u username -p database_name > backup.sql

ALTER DATABASE database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

USE database_name;
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

USE database_name;
SET FOREIGN_KEY_CHECKS=0;
DROP PROCEDURE IF EXISTS `convert_gbk_to_utf8`;
DELIMITER //
CREATE PROCEDURE `convert_gbk_to_utf8`() BEGIN
    DECLARE done INT DEFAULT 0;
    DECLARE tableName VARCHAR(255);
    DECLARE cur CURSOR FOR SELECT table_name FROM information_schema.tables WHERE table_schema = 'database_name';
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
    OPEN cur;
    read_loop: LOOP
        FETCH cur INTO tableName;
        IF done THEN
            LEAVE read_loop;
        END IF;
        SET @sql = CONCAT('ALTER TABLE ', tableName, ' CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;');
        PREPARE stmt FROM @sql;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
    END LOOP;
    CLOSE cur;
END //
DELIMITER ;
CALL convert_gbk_to_utf8();
SET FOREIGN_KEY_CHECKS=1;
DROP PROCEDURE convert_gbk_to_utf8;

ALTER TABLE table_name MODIFY column_name VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

define('DB_CHARSET', 'utf8mb4');

iconv -f gbk -t utf8 input_file > output_file