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 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