List:General Discussion« Previous MessageNext Message »
From:Red Hope Date:July 24 2007 6:01am
Subject:Re: mysql dump help!
View as plain text  
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 <anandkl@stripped> wrote:

> try this
> 
> mysqldump -u root -ppassword --database test >
> test.sql
> 
> On 7/24/07, Red Hope <red_hope1@stripped> 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 <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
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:   
> http://lists.mysql.com/mysql?unsub=1
> >
> >
> 



       
____________________________________________________________________________________
Need a vacation? Get great deals
to amazing places on Yahoo! Travel.
http://travel.yahoo.com/
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