>> 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;
With this you have to save your text file inside the bin folder of your mysql folder e.g c:\mysql\bin. For it to work. >> >> 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. On the other way we just specify the full pathname to the file. If it's in D:\tmp\text.txt, use: LOAD DATA LOCAL INFILE "D:\\tmp\\text.txt" INTO TABLE tabname; Or: LOAD DATA LOCAL INFILE "D:/tmp/text.txt" INTO TABLE tabname; (courtsy : Paul DuBios) > > 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 --------------------------------------------------------------------- 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