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