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]