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:[EMAIL PROTECTED] Sent: Friday, August 08, 2003 3:24 PM To: Donald Tyler; [EMAIL PROTECTED]; [EMAIL PROTECTED] 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:[EMAIL PROTECTED] > Sent: Friday, August 08, 2003 4:08 PM > To: [EMAIL PROTECTED] > 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:[EMAIL PROTECTED] > Sent: Friday, August 08, 2003 3:07 PM > To: '[EMAIL PROTECTED]' > 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:[EMAIL PROTECTED] > Sent: Friday, August 08, 2003 2:59 PM > To: Donald Tyler; [EMAIL PROTECTED] > 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:[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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
