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 <carlos.proal@stripped> 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/mysql?unsub=1
>
>
____________________________________________________________________________________
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
