Scott Haneda wrote:
> on 02/05/2004 07:29 AM, Michael Stassen at Michael.Stassen@stripped
>>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.?
-B or --batch: prints rows tab-separated and turns off the borders
-N or --skip-column-names: leaves out the header row
So, you probably want
mysql dbname -B -e "SELECT serial FROM serials" >/path/to/outfile
mysql dbname -B -N -e "SELECT serial FROM serials" >/path/to/outfile
>>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.
I didn't mention it, but you can also put the mysql username in the
.my.cnf client section, if it's different from the unix username.
That's documented on the same manual page I already pointed you to.