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 > 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'@'%.toolserver.org' (using > password: YES) when executing 'SELECT INTO OUTFILE' > > > > --- On Mon, 10/5/09, Peter Körner <[email protected]> > wrote: > > From: Peter Körner <[email protected]> > Subject: Re: [Toolserver-l] How to dump databases from > mysql to, public_html > To: [email protected] > 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 ([email protected]) > 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 ([email protected]) > 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 ([email protected]) > 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 ([email protected]) https://lists.wikimedia.org/mailman/listinfo/toolserver-l Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette
