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
