Mysql大表迁移

1.secure_file_priv=D:\ComputerProject\project\mysql-8.0.25-winx64

2.select * from bc_leibie into outfile 'D:\AAAAAAAAA\fans.txt';  

3.show variables like '%secure%';
select @@basedir from dual;

4.select * from bc_leibie into outfile 'D:/ComputerProject/project/mysql-8.0.25-winx64/fanspp.txt';  

5.load data infile 'D:/ComputerProject/project/mysql-8.0.25-winx64/fanspp.txt' INTO  TABLE
`bc_leibie_copy1` (
    `id`,
    `parent_id`,
    `parent_ids`,
    `english_name`,
    `chinese_name`,
    `game_code`,
    `game_type`,
    `number_of_players`,
    `maximum_win`,
    `scene_id`,
    `lines`,
    `min_bet`,
    `max_bet`,
    `default_rtp`,
    `free_games_support`,
    `icon_url`,
    `bw_id` 
);