From: Mogens Melander
Date: July 24 2007 3:02am
Subject: Re: mysql dump help!
List-Archive: http://lists.mysql.com/mysql/208201
Message-Id: <1776.90.184.16.67.1185246174.squirrel@mail.fumlersoft.dk>
MIME-Version: 1.0
Content-Type: text/plain;charset=utf-8
Content-Transfer-Encoding: 8bit

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=mogens@stripped
>
>
> --
> 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.