NYCPHP Meetup

[Tim Gales]

Peter,

I am assuming you are using phpMyAdmin --
Try this: when you export the data use data and structure and click 
'add drop table' .
(Copy your table first of course, before trying this --
Or use a test table...)

-----Original Message-----
From: Peter Lehrer [mailto:pl at eskimo.com] 
Sent: Saturday, May 17, 2003 8:50 PM
To: NYPHP Talk
Subject: [nycphp-talk] LOAD DATA LOCAL INFILE

I am using LOAD DATA LOCAL and I get this error message:

mysql> LOAD DATA LOCAL INFILE "down.dat" INTO TABLE 1rc;
ERROR 1148: The used command is not allowed with this MySQL version

The MySQL version is 3.23.49-log.
This error occurs both on Widnows 95 and RedHat 6.1.

The MySQL manual says that the LOCAL option should work on versions
3.22.15 and above so I don't know why it working on my version.

Any help in getting LOAD DATA LOCAL to work would be great.

Peter Lehrer



--- Unsubscribe at http://nyphp.org/list/ ---



---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.480 / Virus Database: 276 - Release Date: 5/12/2003
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.480 / Virus Database: 276 - Release Date: 5/12/2003