Re: [Toolserver-l] How to dump databases from mysql to, public_html

2009-10-08 Thread Peter Körner
> You can find that answer by googling "mysql utf-8". Take a look on the manual: http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html Peter ___ Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/t

Re: [Toolserver-l] How to dump databases from mysql to, public_html

2009-10-07 Thread Jeff Ferland
y' > outfile The data file I received is ANSI not UTF -8. Is there any way? Thanks --- On Mon, 10/5/09, Jeff Ferland wrote: From: Jeff Ferland Subject: Re: [Toolserver-l] How to dump databases from mysql to, public_html To: toolserver-l@lists.wikimedia.org Date: Monday, October 5, 2009

Re: [Toolserver-l] How to dump databases from mysql to, public_html

2009-10-07 Thread Fuz Kabir
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 wrote: > From: Jeff Ferland > Subject: Re: [Toolserver-l] How to dump databases from mysql t

Re: [Toolserver-l] How to dump databases from mysql to, public_html

2009-10-05 Thread Fuz Kabir
Thanks a lot. It's working! --- On Mon, 10/5/09, Jeff Ferland wrote: From: Jeff Ferland 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 h

Re: [Toolserver-l] How to dump databases from mysql to, public_html

2009-10-05 Thread Jeff Ferland
ic_html u_fuzkabir University; same error mysqldump: Got error: 1045: Access denied for user 'fuzkabir'@'%.toolserver.org' (using password: YES) when executing 'SELECT INTO OUTFILE' --- On Mon, 10/5/09, Peter Körner wrote: From: Peter Körner Subject: Re: [T

Re: [Toolserver-l] How to dump databases from mysql to, public_html

2009-10-05 Thread Fuz Kabir
er Körner wrote: From: Peter Körner Subject: Re: [Toolserver-l] How to dump databases from mysql to, public_html To: toolserver-l@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 &g

Re: [Toolserver-l] How to dump databases from mysql to, public_html

2009-10-05 Thread Peter Körner
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 (Tools

Re: [Toolserver-l] How to dump databases from mysql to, public_html

2009-10-05 Thread Fuz Kabir
On Sun, 10/4/09, Jeff Ferland wrote: From: Jeff Ferland Subject: Re: [Toolserver-l] How to dump databases from mysql to, public_html To: toolserver-l@lists.wikimedia.org Date: Sunday, October 4, 2009, 6:04 PM Skip the username and password part too. On the toolserver, mysqldump  should be pull

Re: [Toolserver-l] How to dump databases from mysql to, public_html

2009-10-04 Thread Jeff Ferland
Skip the username and password part too. On the toolserver, mysqldump should be pulling your username & password from the config file. Specify the host (as by default, it won't connect to the local machine which is running no db). The standard format is listing the database as an argument,

Re: [Toolserver-l] How to dump databases from mysql to, public_html

2009-10-04 Thread Platonides
Tim Alder wrote: > Hello, > try "/home/fuzkabir/public_html" instead of > "/$home/fuzkabir/public_html" . > > What works for me is: > mysqldump u_kolossos_databaseX tableXXX > XXX.sql > > Greetings Kolossos > >>> mysqldump u- username -p password `u_fuzkabir`.`university` > >>> /$home/fuzkab

Re: [Toolserver-l] How to dump databases from mysql to, public_html

2009-10-04 Thread Tim Alder
Hello, try "/home/fuzkabir/public_html" instead of "/$home/fuzkabir/public_html" . What works for me is: mysqldump u_kolossos_databaseX tableXXX > XXX.sql Greetings Kolossos >> mysqldump u- username -p password `u_fuzkabir`.`university` > >> /$home/fuzkabir/public_html; >> ___

Re: [Toolserver-l] How to dump databases from mysql to public_html

2009-10-04 Thread Marco Schuster
On Sun, Oct 4, 2009 at 12:46 PM, Fuz Kabir wrote: > I have been trying this for a long. I have a table "university" in my > database which i want to export as mysql dump to my > /$home/fuzkabir/public_html folder > I tried in mysql > >mysqldump u- username -p password `u_fuzkabir`.`university` >

[Toolserver-l] How to dump databases from mysql to public_html

2009-10-04 Thread Fuz Kabir
I have been trying this for a long. I have a table "university" in my database which i want to export as mysql dump to my /$home/fuzkabir/public_html folder I tried in mysql >mysqldump u- username -p password `u_fuzkabir`.`university` > >/$home/fuzkabir/public_html; may be there's a mistake.