FW: mysql LOAD DATA INFILE

[Donald Tyler]

Then the only way you can do it that I can think of is to write a PHP script
to do basically what PHPMyAdmin is trying to do but without the LOCAL in
there.

However to do that you would need to be able to place the PHP file on the
server, and I guess you probably can't do that either. Talk about catch
22...

The only other way I can think of is to install MySQL on a machine you
control, then import the data there using the method I suggested earlier.

Once you have done that, you can use PHPMyAdmin to export the database from
your machine. It should give you a SQL command that will create the data on
another machine. Just copy and paste that into the SQL window on the main
server and that will insert it.

It's a little messy but that's the only other way I can think of doing it.
Sorry.

-----Original Message-----
From: Mike At Spy [mailto:sp*******@spyproductions.com]
Sent: Friday, August 08, 2003 3:24 PM
To: Donald Tyler; my***@lists.mysql.com; ja***********@niicommunications.com
Subject: RE: mysql LOAD DATA INFILE
Ah. No wonder it dinna work. Neither did specifying the columns as Jay
suggested.

I also have no choice but to do it through the browser - I don't have
command line access on the server. :\

-Mike

-----Original Message-----
From: Donald Tyler [mailto:dt****@frazerbilt.com]
Sent: Friday, August 08, 2003 4:08 PM
To: my***@lists.mysql.com
Subject: RE: mysql LOAD DATA INFILE
Oh and just a note. This solution won't work if you are uploading the file
to the server through the browser. You will need to put the file on the
server and adjust the commands PATH accordingly.

-----Original Message-----
From: Donald Tyler [mailto:dt****@frazerbilt.com]
Sent: Friday, August 08, 2003 3:07 PM
To: 'my***@lists.mysql.com'
Subject: FW: mysql LOAD DATA INFILE

I see you still have the word LOCAL in there. Did you try and remove it?

To do that in PHPMyAdmin you will need to run the import so you get the
error message and then copy and paste it into the SQL section of the
PHPMyadmin tool. Delete the world LOCAL and then run the query. It should
work.

-----Original Message-----
From: Mike At Spy [mailto:sp*******@spyproductions.com]
Sent: Friday, August 08, 2003 2:59 PM
To: Donald Tyler; my***@lists.mysql.com
Subject: RE: mysql LOAD DATA INFILE
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:dt****@frazerbilt.com]
Sent: Friday, August 08, 2003 3:42 PM
To: my***@lists.mysql.com
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:sp*******@spyproductions.com]
Sent: Friday, August 08, 2003 2:35 PM
To: my***@lists.mysql.com
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/mysql?unsub=d...frazerbilt.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=s...roductions.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:

http://lists.mysql.com/mysql?unsub=s...roductions.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw