<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Thanks a lot. <br>It's working!<br><br>--- On <b>Mon, 10/5/09, Jeff Ferland <i><jeff@storyinmemo.com></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Jeff Ferland <jeff@storyinmemo.com><br>Subject: Re: [Toolserver-l] How to dump databases from mysql to, public_html<br>To: toolserver-l@lists.wikimedia.org<br>Date: Monday, October 5, 2009, 11:33 AM<br><br><div id="yiv101538883"><div>The command is right, but you don't have SELECT INTO OUTFILE privileges on the server. Try this:</div><div><br></div><div>mysql -h sql u_fuzkabir -e 'select * from university' > outfile</div><div><br></div><div>-Jeff</div><br><div><div>On Oct 5, 2009, at 7:29 AM, Fuz Kabir wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><table style="" border="0" cellpadding="0"
cellspacing="0"><tbody><tr><td style="font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-size: inherit; line-height: inherit; font-size-adjust: inherit; font-stretch: inherit; -x-system-font: none;" valign="top">Yes, but before I tried <br>$ mysqldump -h sql -T ~/public_html u_fuzkabir University;<br>same error<br><br>mysqldump: Got error: 1045: Access denied for user 'fuzkabir'@'%.toolserver.org' (using password: YES) when executing 'SELECT INTO OUTFILE'<br><br><br><br>--- On <b>Mon, 10/5/09, Peter Körner <i><<a rel="nofollow" ymailto="mailto:osm-lists@mazdermind.de" target="_blank" href="/mc/compose?to=osm-lists@mazdermind.de">osm-lists@mazdermind.de</a>></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Peter Körner <<a rel="nofollow" ymailto="mailto:osm-lists@mazdermind.de" target="_blank"
href="/mc/compose?to=osm-lists@mazdermind.de">osm-lists@mazdermind.de</a>><br>Subject: Re: [Toolserver-l] How to dump databases from mysql to, public_html<br>To: <a rel="nofollow" ymailto="mailto:toolserver-l@lists.wikimedia.org" target="_blank" href="/mc/compose?to=toolserver-l@lists.wikimedia.org">toolserver-l@lists.wikimedia.org</a><br>Date: Monday, October 5, 2009, 10:55 AM<br><br><div class="plainMail">Fuz Kabir schrieb:<br>> Thanks, it works!<br>> But I have been failure dumping csv / tab delimited file<br>> using<br>> $ mysqldump -T ~/public_html
u_fuzkabir University;<br>> results<br>You're missing the host-option -h again.<br><br>Peter<br><br>_______________________________________________<br>Toolserver-l mailing list (<a rel="nofollow">Toolserver-l@lists.wikimedia.org</a>)<br><a rel="nofollow" target="_blank" href="https://lists.wikimedia.org/mailman/listinfo/toolserver-l">https://lists.wikimedia.org/mailman/listinfo/toolserver-l</a><br>Posting guidelines for this list: <a rel="nofollow" target="_blank" href="https://wiki.toolserver.org/view/Mailing_list_etiquette">https://wiki.toolserver.org/view/Mailing_list_etiquette</a><br></div></blockquote></td></tr></tbody></table><br>
_______________________________________________<br>Toolserver-l mailing list (<a rel="nofollow" ymailto="mailto:Toolserver-l@lists.wikimedia.org" target="_blank" href="/mc/compose?to=Toolserver-l@lists.wikimedia.org">Toolserver-l@lists.wikimedia.org</a>)<br><a rel="nofollow" target="_blank" href="https://lists.wikimedia.org/mailman/listinfo/toolserver-l">https://lists.wikimedia.org/mailman/listinfo/toolserver-l</a><br>Posting guidelines for this list: <a rel="nofollow" target="_blank" href="https://wiki.toolserver.org/view/Mailing_list_etiquette">https://wiki.toolserver.org/view/Mailing_list_etiquette</a></blockquote></div><br></div><br>-----Inline Attachment Follows-----<br><br><div class="plainMail">_______________________________________________<br>Toolserver-l mailing list (<a ymailto="mailto:Toolserver-l@lists.wikimedia.org" href="/mc/compose?to=Toolserver-l@lists.wikimedia.org">Toolserver-l@lists.wikimedia.org</a>)<br><a
href="https://lists.wikimedia.org/mailman/listinfo/toolserver-l" target="_blank">https://lists.wikimedia.org/mailman/listinfo/toolserver-l</a><br>Posting guidelines for this list: <a href="https://wiki.toolserver.org/view/Mailing_list_etiquette" target="_blank">https://wiki.toolserver.org/view/Mailing_list_etiquette</a></div></blockquote></td></tr></table><br>