Mike,
There's another thread in this group 'Probleem with data import from text
file'. In one of the messages you'll find 'There was a bug in v4.0.12 for
Windows: binary packages were compiled without --enable-local-infile.'
Might apply to you too.
HansH
P.S.: Running on W-XP I cann't get it to work in 4.0.13, 4.0.14b or 4.1 ..
... running server and client on one machine saved my day.
Mike At Spy wrote:
> Sorry, that is the error - my mistake. I am getting this:
>
> LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS
> TERMINATED BY ';' LINES TERMINATED BY '\r\n'
>
> I am using phpMyAdmin 2.3.3 - would an upgrade to the latest version
> remedy the issue?
>
> Thanks,
>
> -Mike
>
>
>
>> -----Original Message-----
>> From: Donald Tyler [mailto:[EMAIL PROTECTED]
>> Sent: Friday, August 08, 2003 3:42 PM
>> To: [EMAIL PROTECTED]
>> Subject: RE: mysql LOAD DATA INFILE
>>
>>
>> PHPMyAdmin uses the "LOAD DATA LOCAL INFILE" command. Just remove
>> the word LOCAL and it should work fine.
>>
>> -----Original Message-----
>> From: Mike At Spy [mailto:[EMAIL PROTECTED]
>> Sent: Friday, August 08, 2003 2:35 PM
>> To: [EMAIL PROTECTED]
>> Subject: mysql LOAD DATA INFILE
>>
>>
>> When I come across this error:
>>
>> The used command is not allowed with this MySQL version
>>
>> Does this mean that I need a whole different verison of MySQL, or
>> just a different compile? The command was 'LOAD DATA INFILE' and I
>> was doing it through phpMyAdmin.
>>
>> Thanks,
>>
>> -Mike
>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
