List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:July 24 2007 5:54am
Subject:Re: mysql dump help!
View as plain text  
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
>
>

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