List:General Discussion« Previous MessageNext Message »
From:Jaime Crespo Rincón Date:October 29 2009 5:31pm
Subject:Re: Choose certain columns in mysqldump?
View as plain text  
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]"


-- 
Jaime Crespo
MySQL & Java Instructor
Warp Networks
<http://warp.es>
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