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

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