From: Date: March 16 2003 9:18pm Subject: Re: INTO LOCAL OUTFILE? List-Archive: http://lists.mysql.com/mysql/134851 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" ; format="flowed" At 10:34 -0900 3/16/03, Tim Johnson wrote: >Hi Paul: >* Paul DuBois [030316 09:59]: >> 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 > > Paul, that works just fine. I note that column names > are inserted as the first line. Is there a way to eliminate > that? If not, that is just fine. Yes, use either the --skip-column-names or -N option. Alternatively, use -ss ("double silent"), but's mainly for versions older then 3.22.20 that don't support --skip-column-names/-N. > > Thank you very much > -tim- > >-- >Tim Johnson > http://www.alaska-internet-solutions.com > http://www.johnsons-web.com -- Paul DuBois http://www.kitebird.com/ sql, query