At 9:14 -0900 3/16/03, Tim Johnson wrote:
Hello All:
    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

    TIA
--
Tim Johnson <[EMAIL PROTECTED]>
      http://www.alaska-internet-solutions.com
      http://www.johnsons-web.com


--
Paul DuBois
http://www.kitebird.com/
sql, query

---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



Reply via email to