千万条数据快速导出mysql

mysqldump -u username -p database_name table_name > export.sql

SELECT * FROM table_name WHERE id BETWEEN 1 AND 1000000 INTO OUTFILE '/path/to/export.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n';

DELIMITER //

CREATE PROCEDURE export_data()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE start_id INT DEFAULT 1;
    DECLARE end_id INT DEFAULT 1000000;

    WHILE NOT done DO
        SELECT * INTO OUTFILE '/path/to/export.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'
        FROM table_name
        WHERE id BETWEEN start_id AND end_id;

        SET start_id = end_id + 1;
        SET end_id = end_id + 1000000;

        IF end_id > (SELECT MAX(id) FROM table_name) THEN
            SET done = TRUE;
        END IF;
    END WHILE;
END //

DELIMITER ;

CALL export_data();