<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2712.300" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=403482205-18012002><FONT face="Lucida Sans Unicode" size=2>i
believe if you simply add it to the appropriate table (user) and set the
appropriate privlidges - then flush privliges and tables - then try the dump
-</FONT></SPAN></DIV>
<DIV><SPAN class=403482205-18012002><FONT face="Lucida Sans Unicode"
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=403482205-18012002><FONT face="Lucida Sans Unicode"
size=2>note: i didn't actually try this on my database, but it *should*
work.</FONT></SPAN></DIV>
<DIV><SPAN class=403482205-18012002><FONT face="Lucida Sans Unicode"
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=403482205-18012002><FONT face="Lucida Sans Unicode"
size=2>otherwise, i bet if you muck around in the archives for awhile you will
find a better answer than i can give you.</FONT></SPAN></DIV>
<DIV><SPAN class=403482205-18012002><FONT face="Lucida Sans Unicode"
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=403482205-18012002><FONT face="Lucida Sans Unicode" size=2><A
href="http://www.mysql.com/documentation/searchlists.html">http://www.mysql.com/documentation/searchlists.html</A></FONT></SPAN></DIV>
<DIV><SPAN class=403482205-18012002><FONT face="Lucida Sans Unicode"
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=403482205-18012002><FONT face="Lucida Sans Unicode" size=2>good
luck!</FONT></SPAN></DIV>
<DIV><SPAN class=403482205-18012002><FONT face="Lucida Sans Unicode"
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=403482205-18012002><FONT face="Lucida Sans Unicode"
size=2>jd</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
tclug-list-admin@mn-linux.org [mailto:tclug-list-admin@mn-linux.org]<B>On
Behalf Of </B>Raymond Norton<BR><B>Sent:</B> Thursday, January 17, 2002 11:11
AM<BR><B>To:</B> tclug-list@mn-linux.org<BR><B>Subject:</B> [TCLUG] mysqldump
mysqladmin<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I am messing with more MySql, trying to dump
tables to .txt files. I am getting permission denied within this:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>mysqldump -uroot -p Meet_A_Geek Customers
>MeetAGeek_Customers.txt</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I get the same without specifying the user. I was
messing with mysqladmin and getting the same type of problems, when I
discovered the password is blank, nothing there. It gives me the info I need
without any password. I looked up how to change it, but all I can find is info
on changing it from one password to another. I am guessing the problems are
related. Can I get any pointers on how to set the password and get a
successful dump?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial
size=2>Raymond</FONT></DIV></FONT></DIV></BLOCKQUOTE></BODY></HTML>