Re: mysqldump dumping a table but not all columns?

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

Re: mysqldump dumping a table but not all columns?

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

mysqldump dumping a table but not all columns?

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