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