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 <[EMAIL PROTECTED]> 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! > - [EMAIL PROTECTED] - http://www.pc.nu > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]