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

Fuz Kabir fuzkabir at yahoo.com
Wed Oct 7 10:38:27 UTC 2009


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 at storyinmemo.com> wrote:

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


      



More information about the Toolserver-l mailing list