Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

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

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

-- First enable the local variable [local_infile] and quit.
mysql> SET GLOBAL local_infile=1;
mysql> quit
-- Reconnect using your credentials:
mysql --local-infile=1 -u root -p1
-- Load your data, example:
mysql> load data local infile '/path/pet.txt' into table pet;
-- Enjoy!
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #ERROR #Loading #local #data #enabled #client #server #sides
ADD COMMENT
Topic
Name
8+1 =