List:General Discussion« Previous MessageNext Message »
From:walter harms Date:October 29 2009 5:39pm
Subject:Re: Choose certain columns in mysqldump?
View as plain text  

Jaime Crespo Rincón schrieb:
> 2009/10/29 Michael Dykman <mdykman@stripped>:
>> mysqldump is not really a data manipulation tool.. as the name
>> implies, it is a dumper.
>>
>> What you are trying to accomlish can be done rather elegantly via the
>> SELECT .. INTO OUTFILE syntax
>>
>>                    http://dev.mysql.com/doc/refman/5.1/en/select.html
>>
>> and then loaded into your new structure via LOAD INFILE
>>
>>                    http://dev.mysql.com/doc/refman/5.1/en/load-data.html
> 
> Yes, in fact, you can still do it from the command line with mysql
> command line client:
> 
> mysql -urxxxt -pxxx db_name -e "SELECT [any, column, you, want] INTO
> OUTFILE '/var/www/folder/table_name.txt' FROM table_name WHERE [any,
> filter, you, want] ORDER BY [any, order, you, want]"
> 
> 
I prefer mysql -BAN ....
It has the advantage that you do not need to fiddle with headers etc.

re,
 wh



Thread
Choose certain columns in mysqldump?Brian Dunning29 Oct
  • Re: Choose certain columns in mysqldump?Michael Dykman29 Oct
    • Re: Choose certain columns in mysqldump?Jaime Crespo Rinc√≥n29 Oct
      • Re: Choose certain columns in mysqldump?walter harms29 Oct
  • Re: Choose certain columns in mysqldump?Brian Dunning4 Nov