[lordmerlin]

How do I do this?

I want to from a table, called companies, dump "compid,company,classificationids" into a text file, but I can't seem todo this. I tried the following, and get an error:

mysql> select compid,company,classificationids from companies where referer="Matrix MArketing" into outfile "/home/tradeleads/matrix_marketing.sql" fields terminated by ',' optionally enclosed by '"' lines terminated by "\n";
ERROR 1: Can't create/write to file '/home/tradeleads/matrix_marketing.sql' (Errcode: 13)
mysql>


I also tried it with mysqldump, but it doesn't output anything. Is there a way of dumping only certain columns from a certain table?

[tega]

You it sounds like you are trying to dump into a file that mysql cant write to. Check you dir permissions. Also try dumping to tmp.

Originally Posted by lordmerlin

How do I do this?

I want to from a table, called companies, dump "compid,company,classificationids" into a text file, but I can't seem todo this. I tried the following, and get an error:

mysql> select compid,company,classificationids from companies where referer="Matrix MArketing" into outfile "/home/tradeleads/matrix_marketing.sql" fields terminated by ',' optionally enclosed by '"' lines terminated by "\n";
ERROR 1: Can't create/write to file '/home/tradeleads/matrix_marketing.sql' (Errcode: 13)
mysql>


I also tried it with mysqldump, but it doesn't output anything. Is there a way of dumping only certain columns from a certain table?