Re: mysqldump dumping a table but not all columns?

[Gleb Paharenko <suppressed>]

Hello.

As far as I know - it is impossible with mysqldump. You may want to
use SELECT INTO OUTFILE to produce files with certain columns or
create tab-separated files with --tab option and load specific columns
using LOAD DATA INFILE. See:
  http://dev.mysql.com/doc/refman/5.0/en/select.html




Test USER wrote:
> i�m using mysqldump to dump some tables and then load it into another mysql 
> server with mysql command.
> 
> but can i specify what columns in the tables to dump?
> 
> i�m using something like this now
> 
> mysqldump -h localhost -u root db tbl | mysql -h xxx.xxx.xxx -u login -pass -w 
> db
> 
> -------------------------------------------------
> FREE E-MAIL IN 1 MINUTE!
>  - suppressed - http://www.pc.nu
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   suppressed
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/suppressed