If LOCAL capability is disabled, on either the server or client side, a client that attempts to issue a LOAD DATA LOCAL statement receives the following error message: ERROR 3950 (42000): Loading local data is disabled this must beĮnabled on both the client and server side csv file into MySQL using the command line shell. (uniq_id, product_name, manufacturer, price, number_available_in_stock, number_of_reviews, number_of_answered_questions, average_review_rating, amazon_category_and_sub_category, customers_who_bought_this_item_also_bought, description, product_information, product_description, items_customers_buy_after_viewing_this_item, customer_questions_and_answers, customer_reviews, sellers) LOAD DATA LOCAL INFILE ‘/Users/BruddaDave/Desktop/amazonsample.csv’ INTO TABLE toys Items_customers_buy_after_viewing_this_item VARCHAR(1000),Ĭustomer_questions_and_answers VARCHAR(1000), Number_available_in_stock VARCHAR (1000),Īmazon_category_and_sub_category VARCHAR(1000),Ĭustomers_who_bought_this_item_also_bought VARCHAR(1000), ERROR 3948 (42000): Loading local data is disabled this must be enabled on both the client and server sides I'm not tech savvy at all, and I just want to be able to get to the point where the data has been uploaded into MySQL workbench. It seems like I've enabled local data on the client side, but I don't know what instructions I need to give my computer to enable the "server side". I'd greatly appreciate if someone could walk me through, step by step, what I need to do to enable local data on the "client" side and "server" side. Mysql> SHOW GLOBAL VARIABLES LIKE 'local_infile' īy this I mean the exact code was provided. I don't understand the responses that others have provided to similar questions except for the most obvious ones, such as the one below: mysql> SET GLOBAL local_infile=1
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |