List:General Discussion« Previous MessageNext Message »
From:Mogens Melander Date:July 24 2007 3:02am
Subject:Re: mysql dump help!
View as plain text  
mysqldump -u <user> -p -q --single-transaction --tab=/dest/dir database

or

mysql -u root -p<password> database > output.sql

On Tue, July 24, 2007 03:16, 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.

Hmmm, try \q<enter> before typing mysqldump ;^)

>
> 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
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>


-- 
Later

Mogens Melander
+45 40 85 71 38
+66 870 133 224



-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

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