[PHP-DB] OUTFILE

[Jonatan Pugliese.]

How to use OUTFILE function in mysql and linux?



Jonatan Pugliese
Area Sistemas
ACA - Automovil club Argentino
4808-4676 / 4663
www.aca.org.ar  

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] OUTFILE

[Nitin]

select column list into OUTFILE filename from tablename

Enjoy happy programming
Nitin


- Original Message - 
From: Jonatan Pugliese. [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 25, 2003 6:59 PM
Subject: [PHP-DB] OUTFILE


 How to use OUTFILE function in mysql and linux?
 
 
 
 Jonatan Pugliese
 Area Sistemas
 ACA - Automovil club Argentino
 4808-4676 / 4663
 www.aca.org.ar  
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 

[PHP-DB] outfile permission error

[James Kupernik]

I'm trying to create a new file on my server from the data in a table. When
I do the query it returns a permission error. I'm logged into my server
through a telnet sessions and the permissions on the dir allow me to write
to it. Here is the query below.

mysql select * into outfile /home/u1/me/www.somesite.com/catalogreq/
catalog.txt
- fields terminated by ',' optionally enclosed by ''
- lines terminated by \n
- FROM catalogs;
ERROR 1045: Access denied for user: 'me@localhost' (Using password: YES)

Any help you be great!! This really has me and my server admin confused.




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]