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