List:General Discussion« Previous MessageNext Message »
From:Red Hope Date:July 24 2007 5:48am
Subject:Re: mysql dump help!
View as plain text  
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 
Thread
mysql dump help!Red Hope24 Jul
  • Re: mysql dump help!Carlos Proal24 Jul
    • Re: mysql dump help!Red Hope24 Jul
      • Re: mysql dump help!Carlos Proal24 Jul
        • Re: mysql dump help!Red Hope24 Jul
          • Re: mysql dump help!Carlos Proal24 Jul
            • Re: mysql dump help!Mogens Melander24 Jul
            • Re: mysql dump help!Red Hope24 Jul
              • Re: mysql dump help!Ananda Kumar24 Jul
                • Re: mysql dump help!Red Hope24 Jul
                • Re: mysql dump help!Ofer Inbar24 Jul
              • Re: mysql dump help!Carlos Proal24 Jul
                • Re: mysql dump help!Red Hope24 Jul
                  • Re: mysql dump help!Ananda Kumar24 Jul
                  • Re: mysql dump help!Gary Josack24 Jul
                    • RE: mysql dump help!Benjamin Wiechman24 Jul
                    • Re: mysql dump help!Red Hope24 Jul
          • Hashing PartitioningDmitry27 Jul
  • Re: mysql dump help!Mogens Melander24 Jul