The command is right, but you don't have SELECT INTO OUTFILE privileges on the server. Try this:

mysql -h sql u_fuzkabir -e 'select * from university' > outfile

-Jeff

On Oct 5, 2009, at 7:29 AM, Fuz Kabir wrote:

Yes, but before I tried
$ mysqldump -h sql  -T ~/public_html u_fuzkabir University;
same error

mysqldump: Got error: 1045: Access denied for user 'fuzkabir'@'%.toolserver.org' (using password: YES) when executing 'SELECT INTO OUTFILE'



--- On Mon, 10/5/09, Peter Körner <osm-lists@mazdermind.de> wrote:

From: Peter Körner <osm-lists@mazdermind.de>
Subject: Re: [Toolserver-l] How to dump databases from mysql to, public_html
To: toolserver-l@lists.wikimedia.org
Date: Monday, October 5, 2009, 10:55 AM

Fuz Kabir schrieb:
> Thanks, it works!
> But I have been failure dumping csv / tab delimited file
> using
> $ mysqldump -T ~/public_html u_fuzkabir University;
> results
You're missing the host-option -h again.

Peter

_______________________________________________
Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette

_______________________________________________
Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette