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

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

Thanks a lot. It's working!

--- On Mon, 10/5/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: Monday, October 5, 2009, 11:33 AM

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

-----Inline Attachment Follows-----

_______________________________________________ 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

Try

mysql --default-character-set=utf8 -h sql u_fuzkabir -e 'select * from university' > outfile

You can find that answer by googling "mysql utf-8".

-Jeff

On Oct 7, 2009, at 6:38 AM, Fuz Kabir wrote:

with mysql -h sql u_fuzkabir -e 'select * from university' > outfile The data file I received is ANSI not UTF -8. Is there any way? Thanks --- On Mon, 10/5/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: Monday, October 5, 2009, 11:33 AM 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