> Hi, > I am having problems loading data into a table and have 2 questions. > > 1) > I want to load some data from a text file in to a table by using the > following line: > LOAD DATA LOCAL INTO "st.txt" INTO TABLE studio; > > this keeps giving me : File "st.txt" not found (ErrorCode: 2) > > Where should I store the st.txt file. I am using Windows and have mysql > stored at c:\mysql. I have tried putting the file in the following > locations: C:\mysql, C:\mysql\data, and C:\mysql\data\[DATABASE NAME](where > the tables are stored) > But keep getting the error.
I'm using the same arrangement and found I had to put my data files under my cgi-bin directory. But when I upload the code to my ISP, they can be stored in the same directory as the script. This tells me it is likely a configuration thing. -- Amer Neely [EMAIL PROTECTED] Softouch Information Services: www.softouch.on.ca/ Perl / PHP / CGI programming for shopping carts, data entry forms. "We make web sites work!" --------------------------------------------------------------------- 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
