Scott Haneda wrote:
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.?
-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
or
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.
Michael
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
