Reqs for LOAD DATA

[ElgisRamon]

Hello.
I'm trying to develop a GUI for the LOAD DATA Sql command.

I coded a form to select a file and send it to a web server, and then I want to "LOAD DATA INFILE '$UpFile'" using PHP, but no avail.

What are the requirements for the webserver user, the mysql user used in the connection, and the permissions on the file and on the tables to run that SQL command?

TIA
I hope it works...
Unix was made by and for smart people.

 

[Cagliostro]

"insert into your_table values($set, $of, $variables, $here)" Ion Filipski

filipski@excite.com

 

[ElgisRamon]

Thank for your answer! But I know how to code dynamic SQL sentences to insert into my tables! I have an almost complete gui for my Web+MySQL server, but I want to initialize my tables from TEXT TAB separated files. And I know how to do a "[tt]LOAD DATA[/tt]" from the MySQL server command line. But now I want give my db operators the possibility to load complete tables!.

Thanks in advance.

BTW I'm running on a Linux machine with PHP4 and MySQL 3.23(?).
I know how to do that "[tt]LOAD DATA[/tt]" when I'm the root user for MySQL on my RS/6000 server.
I hope it works...
Unix was made by and for smart people.

 

[Cagliostro]

happy programming Ion Filipski

filipski@excite.com