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 <[email protected]> wrote:

From: Jeff Ferland <[email protected]>
Subject: Re: [Toolserver-l] How to dump databases from mysql to, public_html
To: [email protected]
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

_______________________________________________
Toolserver-l mailing list ([email protected])
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list: 
https://wiki.toolserver.org/view/Mailing_list_etiquette

Reply via email to