That is messy, but you are right. I have FTP access and such - that's why I was wondering that with the new version of MySQL out, is this a change in MySQL? Or can the people who do have command line access re-compile it or something to give me permission to do what I need to do?
Thanks, -Mike > -----Original Message----- > From: Donald Tyler [mailto:[EMAIL PROTECTED] > Sent: Friday, August 08, 2003 4:30 PM > To: [EMAIL PROTECTED] > Subject: FW: mysql LOAD DATA INFILE > > > 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]