Re: mysqldump dumping a table but not all columns?

[sheeri kritzer <suppressed>]

The mysqldump utility allows granularity up to tables, not columns.

But you can use SELECT ... INTO OUTFILE to export the data:

http://dev.mysql.com/doc/refman/5.1/en/select.html

and then LOAD DATA INFILE (or LOAD DATA LOCAL INFILE) to import it.

-Sheeri

On 12/7/05, Test USER <suppressed> 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
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/suppressed
>
>

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