Support for MYSQL LOAD DATA LOCAL INFILE

About mysql load data local infile support Question 1. run The following command: ERROR 1148 (42000): The used command is not allowed with this MySQL version. Solution: first go to MYSQL and check that version: 5.1 or later is supported. Mysql> select version () 1. this command is not allowed by default during MYSQL compilation and installation. 1) Add the -- enable-local-infile parameter during installation .. /Configure -- prefix =/usr/local/mysql -- enable-local-infilemake www.2cto.com make install 2. You can add the -- local-infile = 1 parameter to the execution hit. For example:/usr/local/mysql/bin/mysql-uroot-h192.168.0.2-proot databaseName -- local-infile = 1-e "load data local infile 'data.txt 'into table test (name, sex )"