Thanks, it works!
But I have been failure dumping csv / tab delimited file
using
$ mysqldump -T ~/public_html u_fuzkabir University;
results

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

previously i also tried using SELECT * from table INTO OUTFILE "path"
 both in phpmyadmin & mysql command prompt

another thing is while i export  csv from phpmyadmin the download limit to approx 11MB. may be for security reasons.

plz suggest me a solution.


--- On Sun, 10/4/09, Jeff Ferland <jeff@storyinmemo.com> wrote:

From: Jeff Ferland <jeff@storyinmemo.com>
Subject: Re: [Toolserver-l] How to dump databases from mysql to, public_html
To: toolserver-l@lists.wikimedia.org
Date: Sunday, October 4, 2009, 6:04 PM

Skip the username and password part too. On the toolserver, mysqldump 
should be pulling your username & password from the config file. 
Specify the host (as by default, it won't connect to the local machine 
which is running no db). The standard format is listing the database 
as an argument, then all tables as following arguments.

$ mysqldump -h sql u_fuzkabir university > ~/public_html/university.sql

That was verified with my own table / db names.

-Jeff

On Oct 4, 2009, at 1:57 PM, Platonides wrote:

> Tim Alder wrote:
>> Hello,
>> try "/home/fuzkabir/public_html" instead of
>> "/$home/fuzkabir/public_html" .
>>
>> What works for me is:
>> mysqldump u_kolossos_databaseX tableXXX > XXX.sql
>>
>> Greetings Kolossos
>>
>>>> mysqldump u- username -p password `u_fuzkabir`.`university` >  /
>>>> $home/fuzkabir/public_html;
>>>>
>
>
> and those ` would be interpreted by the shell.
>
> Try mysqldump -u username -p password '`u_fuzkabir`.`university`' >
> /$HOME/public_html/university.sql
>
> _______________________________________________
> 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