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

List overview All Threads
Download

newer

older

a new way to run tools: batch job...

JIRA upgrade

Tim Alder

4 Oct 2009 4 Oct '09

5:06 p.m.

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

Show replies by date

Platonides

4 Oct 4 Oct

5:57 p.m.

New subject: How to dump databases from mysql to, public_html

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/fuzkabir/public_html; >>

and those ` would be interpreted by the shell. Try mysqldump -u username -p password '`u_fuzkabir`.`university`' > /$HOME/public_html/university.sql

Jeff Ferland

6:04 p.m.

New subject: How to dump databases from mysql to, public_html

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, then all tables as following arguments. $ mysqldump -h sql u_fuzkabir university > ~/public_html/university.sql That was verified with my own table / db names. -Jeff On Oct 4, 2009, at 1:57 PM, Platonides wrote:

...

Tim Alder wrote:

and those ` would be interpreted by the shell. Try mysqldump -u username -p password '`u_fuzkabir`.`university`' > /$HOME/public_html/university.sql _______________________________________________ Toolserver-l mailing list (Toolserver-l(a)lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette

Fuz Kabir

5 Oct 5 Oct

9:16 a.m.

New subject: How to dump databases from mysql to, public_html

Thanks, it works! But I have been failure dumping csv / tab delimited file using $ mysqldump -T ~/public_html u_fuzkabir University; results mysqldump: Got error: 1045: Access denied for user 'fuzkabir'(a)'%.toolserver.org'(using password: YES) when executing 'SELECT INTO OUTFILE' previously i also tried using SELECT * from table INTO OUTFILE "path" both in phpmyadmin & mysql command prompt another thing is while i export csv from phpmyadmin the download limit to approx 11MB. may be for security reasons. plz suggest me a solution. --- On Sun, 10/4/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: Sunday, October 4, 2009, 6:04 PM 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, then all tables as following arguments. $ mysqldump -h sql u_fuzkabir university > ~/public_html/university.sql That was verified with my own table / db names. -Jeff On Oct 4, 2009, at 1:57 PM, Platonides wrote:

...

Tim Alder wrote:

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

Peter Körner

10:55 a.m.

New subject: How to dump databases from mysql to, public_html

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

Fuz Kabir

11:29 a.m.

New subject: How to dump databases from mysql to, public_html

Yes, but before I tried $ mysqldump -h sql -T ~/public_html u_fuzkabir University; same error mysqldump: Got error: 1045: Access denied for user 'fuzkabir'(a)'%.toolserver.org' (using password: YES) when executing 'SELECT INTO OUTFILE' --- On Mon, 10/5/09, Peter Körner <osm-lists(a)mazdermind.de> wrote: From: Peter Körner <osm-lists(a)mazdermind.de> 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, 10:55 AM 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

Jeff Ferland

11:33 a.m.

New subject: How to dump databases from mysql to, public_html

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 On Oct 5, 2009, at 7:29 AM, Fuz Kabir wrote:

...

Thanks, it works! But I have been failure dumping csv / tab delimited file using $ mysqldump -T ~/public_html u_fuzkabir University; results

Fuz Kabir

6 Oct 6 Oct

3:29 a.m.

New subject: How to dump databases from mysql to, public_html

Thanks a lot. It's working! --- 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 On Oct 5, 2009, at 7:29 AM, Fuz Kabir wrote: Yes, but before I tried $ mysqldump -h sql -T ~/public_html u_fuzkabir University; same error mysqldump: Got error: 1045: Access denied for user 'fuzkabir'(a)'%.toolserver.org' (using password: YES) when executing 'SELECT INTO OUTFILE' --- On Mon, 10/5/09, Peter Körner <osm-lists(a)mazdermind.de> wrote: From: Peter Körner <osm-lists(a)mazdermind.de> 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, 10:55 AM 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 (Toolserver-l(a)lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette _______________________________________________ Toolserver-l mailing list (Toolserver-l(a)lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette -----Inline Attachment Follows----- _______________________________________________ Toolserver-l mailing list (Toolserver-l(a)lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette

Fuz Kabir

7 Oct 7 Oct

10:38 a.m.

New subject: How to dump databases from mysql to, public_html

...

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 On Oct 5, 2009, at 7:29 AM, Fuz Kabir wrote: Yes, but before I tried $ mysqldump -h sql -T ~/public_html u_fuzkabir University; same error mysqldump: Got error: 1045: Access denied for user 'fuzkabir'(a)'%.toolserver.org' (using password: YES) when executing 'SELECT INTO OUTFILE' --- On Mon, 10/5/09, Peter Körner <osm-lists(a)mazdermind.de> wrote: From: Peter Körner <osm-lists(a)mazdermind.de> 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, 10:55 AM 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

Jeff Ferland

1:04 p.m.

New subject: How to dump databases from mysql to, public_html

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

Peter Körner

8 Oct 8 Oct

6:55 p.m.

New subject: How to dump databases from mysql to, public_html

...

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

5315

days inactive

5319

days old

toolserver-l@lists.wikimedia.org

Manage subscription

10 comments

5 participants

tags (0)

participants (5)

Fuz Kabir
Jeff Ferland
Peter Körner
Platonides
Tim Alder