List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:July 24 2007 6:33am
Subject:Re: mysql dump help!
View as plain text  
did u try this


mysqldump -u root -ppassword --database test > test.sql


On 7/24/07, Red Hope <red_hope1@stripped> wrote:
>
> I'm curious about one thing. When I go into MySQL
> folder on the hard drive. I go into the 'bin' folder,
> should there be an .exe program called mysqldump? or
> not?
>
> Lillian
>
>
> --- Carlos Proal <carlos.proal@stripped> wrote:
>
> >
> > Yep, good for you, welcome to the "real" world
> > You are changing the prompt but are still inside the
> > dbms, you need to
> > get out, because mysqldump is an application (.exe
> > file) not a sql
> > command, ie
> >
> --------------------------------------------------------------------
> > Welcome to the MySQL monitor.  Commands end with ;
> > or \g.
> > Your MySQL connection id is 9
> > Server version: 5.0.41-community-nt-log MySQL
> > Community Edition (GPL)
> >
> > Type 'help;' or '\h' for help. Type '\c' to clear
> > the buffer.
> >
> > mysql>
> > mysql> quit
> > Bye
> >
> > D:\lillian>mysqldump -u root -ppassword test >
> > test.sql;
> >
> ----------------------------------------------------------
> >
> > but maybe after the quit, the window will close, if
> > that happens, open a
> > new command prompt from "start -> programs ->
> > accesories --> command
> > prompt" and then run mysqldump
> >
> > Carlos
> >
> >
> > Red Hope 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
> >
> >
>
>
>
>
> ____________________________________________________________________________________
> Luggage? GPS? Comic books?
> Check out fitting gifts for grads at Yahoo! Search
> http://search.yahoo.com/search?fr=oni_on_mail&p=graduation+gifts&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