MySQL：mysql8.0命令导入txt文件时The used command is not allowed with this MySQL version

悠悠 2022-04-23 05:32 152阅读 0赞

### 文章目录 ###

*  描述
 *   *  准备txt数据
     *  导入数据
     *  出现错误
 *  解决

建议使用mysqlbench之类的工具导入

# 描述 #

## 准备txt数据 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70]

## 导入数据 ##

(root@localhost) [arguse]> load data local infile '/home/ocean/workspace/mysql/point.txt' into table point;

## 出现错误 ##

ERROR 1148 (42000): The used command is not allowed with this MySQL version

# 解决 #

(root@localhost) [arguse]> show variables like '%infile%';
    +---------------+-------+
    | Variable_name | Value |
    +---------------+-------+
    | local_infile  | OFF   |
    +---------------+-------+
    1 row in set (0.00 sec)
    
    (root@localhost) [arguse]> set global local_infile = 'ON';
    Query OK, 0 rows affected (0.00 sec)
    
    (root@localhost) [arguse]>  load data local infile '/home/ocean/workspace/mysql/point.txt' into table point;
    ERROR 1148 (42000): The used command is not allowed with this MySQL version
    (root@localhost) [arguse]> exit
    
    $ mysql --local-infile=1 -uroot -p
    Enter password: 
    
    (root@localhost) [arguse]>  load data local infile '/home/ocean/workspace/mysql/point.txt' into table point;

错误2：Row 124 doesn’t contain data for all columns  
原因：

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poaXpoZW5nZ3Vhbg_size_16_color_FFFFFF_t_70]: /images/20220323/3a1c0eccc7774397941df39ab1d2710a.png