problem with using "load data local infile" in MyS
Posted 17 May 2003 - 12:29 PM
I am using mysqld-max-nt...
I have check for information in mysql\'s web site,but still can not solve the problem! still can not use load data local infile...
every time it shows me the same error message:
ERROR 1148: The used command is not allowed with this MySQL version
I have tried two ways
1. in the command line of mysql
mysql --local-infile=1 -u root -p
I also tried.....
mysql --local-infile=0 -u root -p
but all can not
2. modify the my.ini
I also tried
but all still can not
so what\'t the problem????
Help me, please...
Tahnks a lot
Posted 17 May 2003 - 05:06 PM
load data infile \'d:/test.txt\' into table test fields terminated by \'t\' lines terminated by \'rn\';
Notice the need to specify the Carriage Return, New Line combination. Without it this doesn\'twork.
Alternatively have you tried
load data local infile ...?
Posted 19 May 2003 - 11:21 AM
u can try this tool found @
Its a nice GUI tool for windows!!
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users