mysql doesn't write any files to any directory other than its data directory, so try:
SELECT * INTO OUTFILE 'Results.txt' FROM Answer; and then copy it whereever you want. HTH Nitin ----- Original Message ----- From: "Rick Duley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Geoff Roy" <[EMAIL PROTECTED]> Sent: Tuesday, March 23, 2004 8:52 AM Subject: Downloading Data > Hi folks > > I am running MySQL 4..0.7-gamma on Red Hat Linux 7.2. > > I wish to download data from my database. > > I have a directory called 'Results' with permissions set to: drwxrwxrwx > > I enter the command: > > SELECT * INTO OUTFILE '/home/rick/Results/Results.txt' FROM Answer; > > and I get: > > ERROR 1045: Access denied for user '[EMAIL PROTECTED]' (Using password: YES) > > The command without the "INTO OUTFILE '/home/rick/Results/Results.txt'" > clause works just fine. > > > Where have I missed the bus? > > Thanks > > ------------------------------------------- > Rick Duley > School of Engineering Science > Murdoch University, Perth, Western Australia > aussie : 0409 106 049 > o'seas : +61 409 106 049 > .-_|\ > "The Main Thing is / \ > to keep the Main Thing perth *_.-._/ > the Main Thing" v > (Stephen Covey, 1994) > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]