将CSV导入MySQL表返回一个错误#1148

Question

当我选择CSV而不使用LOAD数据时，我正在尝试使用DirectAdmin导入--我得到了“第1行CSV输入中无效字段计数”的错误。

当我尝试加载数据时，我得到了以下错误："#1148 -这个MySQL版本不允许使用该命令。“

CSV是在MS Access数据库中创建的。

以下是前2行：

"product_id","vendor_id"," product_parent_id","product_sku","product_s_desc ","product_desc","product_thumb_image ","product_full_image","product_publish","product_weight","product_weight_uom ","product_length ","product_width","product_height ","product_lwh_uom ","disp_order","price","sale","product_url ","product_in_stock","product_available_date","product_availability ","product_special ","product_discount_id ","ship_code_id ","cdate ","mdate ","product_name ","product_sales ","attribute ","custom_attribute ","product_tax_id ","product_unit ","product_packaging ","child_options ","quantity_options ","child_option_ids ","product_order_levels "
41,2,0,1,,,"resized/Krug-Rose-Champagne-lg.jpg","Krug-Rose-Champagne-lg.jpg","Y","750.0000","grams","4.0000","4.0000",14,,14,3516,0,,,1296518400,,"N",0,"NULL ",1296574622,1297953843,"קרוג רוזה",0,,,2,"piece ",65537,"N,N,N,N,N,Y,20%,10%, ","none,0,0,1 ",,"0,0 "

Answer 1

从mysql命令行中传递以下参数：

mysql -u username -p dbname --local-infile

与其使用：load data infile，不如使用：load data local infile，它应该执行导入。

默认情况下，mysql不按照此处定义的安全考虑启用load data local：

http://dev.mysql.com/doc/refman/5.0/en/load-data-local.html

如果在服务器或客户端禁用了LOAD数据本地，试图发出这样一条语句的客户端将收到以下错误消息：

错误1148:此MySQL版本不允许使用的命令