Really the question is will the following work: LOAD DATA INFILE 'home/domain name/www/subdirectory/data.txt' INTO TABLE data FIELDS ENCLOSED BY '"' TERMINATED BY ',' LINES TERMINATED BY ';'; -----Original Message----- From: Hamilton, Jay Sent: Monday, June 18, 2001 4:56 PM To: '[EMAIL PROTECTED]' Subject: I need to use the Load Data command to load the contents of a text file into a table. The problem is the text file resides on a server that holds the website pages. I am new to UNIX. How do I setup the LOAD DATA INFILE command to specify the text file if it is loaded on another server? This is what I have: LOAD DATA INFILE 'data.txt' INTO TABLE data FIELDS ENCLOSED BY '"' TERMINATED BY ',' LINES TERMINATED BY ';'; I need to specify the path for the data.txt file if it is on the websites server. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
