Re: SELECT Into File

This WebDNA talk-list message is from

2006

It keeps the original formatting. numero = 63840
interpreted = N
texte = BTW - MacOSX 3.?; Webstar; WebDNA 6I think I have a problem with this. The permissions are for Webstar to R/W; and WebDNA therefore can do so. The user for MySQL is also Webstar; would there be a different set of permissions in this case?This area always gets me fouled up.LarryOn Jan 16, 2006, at 6:38 PM, Marko Bernyk wrote:> Couls be permissions problem.>> Do you have permissions to write into the directory /Applications/ > 4dwebstar/webserver/> defaultsite/nasdtec/ ???>> Sounds like you do for folder /tmp/>> -- > Regards,> Marko>>> On Tuesday, 17 January 2006 11:09 AM, Larry Hewitt > wrote:> I ran across a thread of this statement with the list about 18 months> ago that seemed to say I figured this out, but I'm stumped.>> This is on our test server:>> This works fine:> SELECT * INTO OUTFILE '/tmp/test.txt' FROM names;>> This doesn't:>> SELECT * INTO OUTFILE '/Applications/4dwebstar/webserver/defaultsite/> nasdtec/test.txt' FROM names;>> [Can't create/write to file '/Applications/4dwebstar/webserver/> defaultsite/nasdtec/test.txt' (Errcode: 13)]>> TIA>> Larry>>>> ---------------------------------------------------------------------- > --> ------> "Democracy is two wolves and a lamb voting on what to have for lunch.> Liberty is a well-armed lamb contesting the vote."> --Benjamin Franklin>> Larry Hewitt 360.807.1100 OFFICE> HCO, LLC 360.807.1103 FAX> 109 No. Tower 360.880.4855 CELL> P.O. Box 1017 larryh@hewittco.com> Centralia, WA 98531 www.votewashington.org> www.hewittco.com>>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.smithmicro.com/>>>>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.smithmicro.com/------------------------------------------------------------------------ ------"Democracy is two wolves and a lamb voting on what to have for lunch.Liberty is a well-armed lamb contesting the vote."--Benjamin FranklinLarry Hewitt 360.807.1100 OFFICEHCO, LLC 360.807.1103 FAX109 No. Tower 360.880.4855 CELLP.O. Box 1017 larryh@hewittco.comCentralia, WA 98531 www.votewashington.orgwww.hewittco.com-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Re: SELECT Into File ( Larry Hewitt 2006)
Re: SELECT Into File ( Larry Hewitt 2006)
Re: SELECT Into File ( Marko Bernyk 2006)
SELECT Into File ( Larry Hewitt 2006)

BTW - MacOSX 3.?; Webstar; WebDNA 6I think I have a problem with this. The permissions are for Webstar to R/W; and WebDNA therefore can do so. The user for MySQL is also Webstar; would there be a different set of permissions in this case?This area always gets me fouled up.LarryOn Jan 16, 2006, at 6:38 PM, Marko Bernyk wrote:> Couls be permissions problem.>> Do you have permissions to write into the directory /Applications/ > 4dwebstar/webserver/> defaultsite/nasdtec/ ???>> Sounds like you do for folder /tmp/>> -- > Regards,> Marko>>> On Tuesday, 17 January 2006 11:09 AM, Larry Hewitt > wrote:> I ran across a thread of this statement with the list about 18 months> ago that seemed to say I figured this out, but I'm stumped.>> This is on our test server:>> This works fine:> SELECT * INTO OUTFILE '/tmp/test.txt' FROM names;>> This doesn't:>> SELECT * INTO OUTFILE '/Applications/4dwebstar/webserver/defaultsite/> nasdtec/test.txt' FROM names;>> [Can't create/write to file '/Applications/4dwebstar/webserver/> defaultsite/nasdtec/test.txt' (Errcode: 13)]>> TIA>> Larry>>>> ---------------------------------------------------------------------- > --> ------> "Democracy is two wolves and a lamb voting on what to have for lunch.> Liberty is a well-armed lamb contesting the vote."> --Benjamin Franklin>> Larry Hewitt 360.807.1100 OFFICE> HCO, LLC 360.807.1103 FAX> 109 No. Tower 360.880.4855 CELL> P.O. Box 1017 larryh@hewittco.com> Centralia, WA 98531 www.votewashington.org> www.hewittco.com>>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.smithmicro.com/>>>>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.smithmicro.com/------------------------------------------------------------------------ ------"Democracy is two wolves and a lamb voting on what to have for lunch.Liberty is a well-armed lamb contesting the vote."--Benjamin FranklinLarry Hewitt 360.807.1100 OFFICEHCO, LLC 360.807.1103 FAX109 No. Tower 360.880.4855 CELLP.O. Box 1017 larryh@hewittco.comCentralia, WA 98531 www.votewashington.orgwww.hewittco.com-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Larry Hewitt

DOWNLOAD WEBDNA NOW!

Re: SELECT Into File

2006

Top Articles:

Related Readings: