At 9:14 -0900 3/16/03, Tim Johnson wrote:
> I am using Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
> I believe that INTO LOCAL OUTFILE is not implemented, but
> all the same, I would like to save a selection set into
> a local output (text) file. Can someone suggest a way to
> use mysqldump to do the same (or any other strategy).
> I've tried using the --tab option but get am getting
> Errcode: 13
There is no analog to INTO LOCAL OUTFILE. You can save the output
of a query executed in mysql to a file, which will give you a tab-delimited
file. In some cases, that may be sufficient.
mysql -e "select * from tbl_name" db_name > output
>Tim Johnson <tim@stripped>