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! > - [EMAIL PROTECTED] - 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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ 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/[EMAIL PROTECTED]