List:General Discussion« Previous MessageNext Message »
From:Red Hope Date:July 24 2007 2:15pm
Subject:Re: mysql dump help!
View as plain text  
I did have some luck, y'all after several hours.
Originally  there wasn't a mysqldump.exe in the bin
folder so I redid everything. I went through regular
ole ms-dos and was able to run it through fine. 

I just needed it to get converted to a .sql file so I
can upload it to my web server. I discovered my web
server only takes .sql files for the database in the
PHPadmin thing.  So I'm hoping it'll work out.

Thank you all for the help. I'd never figured out if
everybody didn't provide the steps to get there! :)

Lillian


--- Gary Josack <gary@stripped> wrote:

> Red Hope 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:   
> 
=== message truncated ===



      ____________________________________________________________________________________
Shape Yahoo! in your own image.  Join our Network Research Panel today!  
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