I cut and pasted what you typed and just altered the password. It didn't like it all. Same error again. If I put any command in without the ";" at the end then I'll get locked into this "->" thingy unless I clear out. I can't guess why it won't take it.
Lillian --- Ananda Kumar <[EMAIL PROTECTED]> wrote: > try this > > mysqldump -u root -ppassword --database test > > test.sql > > On 7/24/07, Red Hope <[EMAIL PROTECTED]> wrote: > > > > Hey y'all, > > I use charming Windows XP on here. I've taken > database > > classes but lucky for me we never used *real* > MySQL. > > Below I typed up exactly what I put into the MySQL > > prompt and this is what it kicks back to me. > > > > Lillian > > > > > > > > mysql> > > > > mysql> \R shell> > > PROMPT set to 'shell>' > > > > shell> > > > > shell>mysqldump -u root -ppassword test > > test.sql; > > ERROR 1064 <4200>: You have an error in your SQL > > syntax; checkthe manual that corresponds to your > MySQL > > server version for the right syntax to use near > > 'mysqldump -u root -ppassword test > test.sql' at > line > > 1 > > > > > > > > --- Carlos Proal <[EMAIL PROTECTED]> wrote: > > > > > > > > Can you email us the complete command and the > error > > > ? > > > > > > Carlos > > > > > > > > > Red Hope wrote: > > > > Well, that went over my head. :) I > understand > > > what > > > > you're telling me, how to get there, but not > how > > > to do > > > > it. bleh. > > > > > > > > When I start up MySQL Command Line Client, I'm > > > always > > > > prompted at "mysql>". So I told it to switch > from > > > that > > > > prompt to "shell>" prompt. It always starts up > in > > > > "mysql>" prompt. Once I'm in shell, I tried > the > > > dump > > > > procedure and it kept saying it couldn't > connect. > > > So I > > > > checked what databases it had, it shows them. > I > > > can't > > > > even switch to a database because of no > > > connection. > > > > I'm not exactly sure why there's no > 'connection' > > > at > > > > all. > > > > > > > > Thanks for trying so hard, Carlos! > > > > Lillian > > > > > > > > > > > > > -- > > > MySQL General Mailing List > > > For list archives: http://lists.mysql.com/mysql > > > To unsubscribe: > > > > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > ____________________________________________________________________________________ > > Got a little couch potato? > > Check out fun summer activities for kids. > > > > > http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&cs=bz > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > ____________________________________________________________________________________ Need a vacation? Get great deals to amazing places on Yahoo! Travel. http://travel.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
