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


--- Carlos Proal <carlos.proal@stripped> wrote:

> 
> Well hopefully, typing "quit" at the mysql console
> get you back to the 
> shell.
> 
> Otherwise, you need to open a Gnome Console, KDE
> Konsole or Windows 
> CommandPrompt from the different menus on your
> operating system
> 
> If the mysql directory is on your PATH you can use
> mysqldump anywhere, 
> if not, move to the mysql/bin directory and then you
> can run it without 
> any problem.
> 
> Hope that help.
> 
> Carlos
> 
> 
> Red Hope wrote:
> > Oh boy, and here's the big stupid question. How do
> I
> > get to the shell prompt? Sorry! Yea, I'm that
> newbie. 
> > :)
> >
> > Thank you,
> > Lillian
> >
> >
> > --- Carlos Proal <carlos.proal@stripped> wrote:
> >
> >   
> >> One common error is trying to do this inside the
> >> mysql console, instead 
> >> of the shell prompt, i think thats your problem
> >> because at least the 
> >> first one is correct.
> >>
> >> Carlos
> >>
> >>
> >> Red Hope wrote:
> >>     
> >>> Hey y'all,
> >>> I've been fussing with the MySQL dump procedure
> to
> >>> backup my stuff. I'm on MySQL 5.0.41 and I have
> >>>       
> >> tried
> >>     
> >>> so hard to get it to dump my files into .sql
> >>>       
> >> format
> >>     
> >>> but my syntax is wrong, wrong, wrong.  lol  
> >>>
> >>> I put below examples what I've been entering to
> >>>       
> >> get my
> >>     
> >>> databases backed up. I always get an error or I
> >>>       
> >> get
> >>     
> >>> locked into the "->" thing if I don't use the
> >>> semicolons. 
> >>>
> >>> Any help would be awesome!
> >>> Thank you,
> >>> Lillian
> >>>
> >>> Tried & Wrong
> >>> mysqldump -u root -ppassword test > test.sql
> >>> mysqldump -u root -ppassword test > test.sql;
> >>> mysqldump -u root -ppassword -databases test >
> >>> test.sql;
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>        
> >>>
> >>>       
> >
>
____________________________________________________________________________________
> >   
> >>> Yahoo! oneSearch: Finally, mobile search 
> >>> that gives answers, not web links. 
> >>>
> >>>       
> >
>
http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC
> >   
> >>>   
> >>>       
> >> -- 
> >> MySQL General Mailing List
> >> For list archives: http://lists.mysql.com/mysql
> >> To unsubscribe:   
> >>
> >>     
> >
>
http://lists.mysql.com/mysql?unsub=1
> >   
> >>     
> >
> >
> >
> >        
> >
>
____________________________________________________________________________________
> > Take the Internet to Go: Yahoo!Go puts the
> Internet in your pocket: mail, news, photos & more. 
> > http://mobile.yahoo.com/go?refer=1GNXIC
> >
> >   
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:   
>
http://lists.mysql.com/mysql?unsub=1
> 
> 



      ____________________________________________________________________________________
Fussy? Opinionated? Impossible to please? Perfect.  Join Yahoo!'s user panel and lay it on
us. http://surveylink.yahoo.com/gmrs/yahoo_panel_invite.asp?a=7 

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