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.
mysql> \R shell>
PROMPT set to '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
--- Carlos Proal <carlos.proal@stripped> wrote:
> Can you email us the complete command and the error
> Red Hope wrote:
> > Well, that went over my head. :) I understand
> > 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
> > prompted at "mysql>". So I told it to switch from
> > prompt to "shell>" prompt. It always starts up in
> > "mysql>" prompt. Once I'm in shell, I tried the
> > procedure and it kept saying it couldn't connect.
> So I
> > checked what databases it had, it shows them. I
> > even switch to a database because of no
> > I'm not exactly sure why there's no 'connection'
> > all.
> > Thanks for trying so hard, Carlos!
> > Lillian
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
Got a little couch potato?
Check out fun summer activities for kids.