LOAD DATA LOCAL INFILE confusion

2004-04-19 Thread Dan Cumpian
Hello, I have a client that can connect to either a local or remote MySQL server. LOAD DATA INFILE works fine on a local server, but obviously fails when a remote server is used. When I add LOCAL to the command, I get: The used command is not allowed with this MySQL version I am using

Load Data Local Infile confusion

2004-04-19 Thread Dan Cumpian
Hello, I have a client that can connect to either a local or remote MySQL server. LOAD DATA INFILE works fine on a local server, but obviously fails when a remote server is used. When I add LOCAL to the command, I get: The used command is not allowed with this MySQL version I am using 4.0.18.