mysql数据太大 如何导入

-- 示例：分批导入数据
SET @batch_size = 10000;
SET @offset = 0;

WHILE (SELECT COUNT(*) FROM your_table WHERE id > @offset) > 0 DO
    INSERT INTO your_table (column1, column2, ...)
    SELECT column1, column2, ...
    FROM your_source_table
    WHERE id > @offset
      AND id <= (@offset + @batch_size);
    SET @offset = @offset + @batch_size;
END WHILE;

# 示例：使用GNU Parallel进行并行导入
cat data.csv | parallel -j 4 "mysql -u username -p password your_database -e 'LOAD DATA INFILE \"STDIN\" INTO TABLE your_table'"

-- 示例：删除不必要的索引
ALTER TABLE your_table DROP INDEX index_name;

-- 导入数据

-- 重新创建索引
ALTER TABLE your_table ADD INDEX index_name (column_name);

# 示例：使用mysqldump进行数据导入
mysqldump -u username -p password your_database > backup.sql
mysql -u username -p password your_database < backup.sql