<p>我不明白其他人對類似問題的回答，除了最明顯的問題，例如下面的問題：</p> <pre class="brush:php;toolbar:false;">mysql> SET GLOBAL local_infile=1; Query OK, 0 rows affected (0.00 sec) mysql> SHOW GLOBAL VARIABLES LIKE 'local_infile'; --------------- ------- | Variable_name | Value | --------------- ------- | local_infile | ON | --------------- ------- 1 row in set (0.01 sec)</pre> <p>我的意思是提供了確切的程式碼。如果有人能夠逐步引導我了解我需要做什麼才能在「客戶端」端和「伺服器」端啟用本地數據，我將不勝感激。似乎我已經在客戶端啟用了​​本地數據，但我不知道需要給我的電腦什麼指令才能啟用「伺服器端」。我根本不懂技術，我只想能夠將資料上傳到 MySQL Workbench。 </p> <pre class="brush:php;toolbar:false;">ERROR 3948 (42000): Loading local data is disabled; this must be enabled on both the client and server sides</pre> <pre class="brush:php;toolbar:false;">CREATE TABLE toys ( uniq_id VARCHAR(1000), product_name VARCHAR(1000), manufacturer VARCHAR(1000), price VARCHAR(1000), number_available_in_stock VARCHAR (1000), number_of_reviews INT, number_of_answered_questions INT, average_review_rating VARCHAR(1000), amazon_category_and_sub_category VARCHAR(1000), customers_who_bought_this_item_also_bought VARCHAR(1000), description VARCHAR(1000), product_information VARCHAR(1000), product_description VARCHAR(1000), items_customers_buy_after_viewing_this_item VARCHAR(1000), customer_questions_and_answers VARCHAR(1000), customer_reviews VARCHAR(1000), sellers VARCHAR(1000) ); LOAD DATA LOCAL INFILE ‘/Users/BruddaDave/Desktop/amazonsample.csv’ INTO TABLE toys FIELDS TERMINATED BY ‘,’ LINES TERMINATED BY ‘n’ IGNORE 1 LINES (uniq_id, 非items_customers_buy_after_viewing_this_item, customer_questions_and_answers, customer_reviews, sellers) ;</pre> <p>我只是希望能夠使用命令列 shell 將 .csv 檔案匯入 MySQL。 </p>

ERROR 3950 (42000): Loading local data is disabled; this must be
enabled on both the client and server side

mysql> SET GLOBAL local_infile=1;
Query OK, 0 rows affected (0.00 sec)

mysql> quit
Bye

mysql --local-infile=1 -u root -p1

mysql> use menagerie
Database changed
mysql> load data local infile '/path/pet.txt' into table pet;
Query OK, 8 rows affected, 7 warnings (0.00 sec)