on 02/05/2004 07:29 AM, Michael Stassen at [EMAIL PROTECTED] wrote: > Also, you need the FILE privilege to SELECT INTO OUTFILE. > > Alternatively, you could simply redirect output to a file. > > mysql dbname -e "SELECT serial FROM serials" >/path/to/outfile > > In this case, the file is written by the user running the cron job, so > that user, not mysql, needs permission to write.
Great idea, how do I get a \r style dump with none of the pretty wrappers around it.? > > Finally, I think it's important to point out that putting -ppass or > --password=pass on the command line is insecure. Any user who runs ps > at the right moment can see the password. The preferred way to do this > is to put the password in the client section of the user's .my.cnf file. > See <http://www.mysql.com/doc/en/Option_files.html> for more. Thanks, great info, I will read into this. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
