By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,896 Members | 1,997 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,896 IT Pros & Developers. It's quick & easy.

FW: mysql LOAD DATA INFILE

P: n/a
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

Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.