Re: Bash script to MySql

[Scott Haneda]

on 02/05/2004 07:29 AM, Michael Stassen at Michael.Stassen@stripped
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: [phone]
http://www.newgeo.com                       Fax: [phone]
scott@stripped                            Novato, CA U.S.A.