如出现以下问题:
1.Loading local data is disabled; this must be enabled on both the client and server sides
2.ERROR3948: Loading local data is disabled - this must be enabled on both the client and server sides
解决办法:
1 登录mysql时: mysql --local-infile=1 -uroot -p
2 设置客户端加载功能: set global local_infile = 1;
加载文件:
load data local infile “文件路径.csv” into table db_name.table_name;