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(a)storyinmemo.com> wrote:
From: Jeff Ferland <jeff(a)storyinmemo.com>
Subject: Re: [Toolserver-l] How to dump databases from mysql to, public_html
To: toolserver-l(a)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'(a)'%.toolserver.org' (using
password: YES) when executing 'SELECT INTO OUTFILE'
--- On Mon, 10/5/09, Peter Körner <osm-lists(a)mazdermind.de>
wrote:
From: Peter Körner <osm-lists(a)mazdermind.de>
Subject: Re: [Toolserver-l] How to dump databases from
mysql to, public_html
To: toolserver-l(a)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(a)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(a)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(a)lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list:
https://wiki.toolserver.org/view/Mailing_list_etiquette