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