mysqldump -u <user> -p -q --single-transaction --tab=/dest/dir database
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
Hmmm, try \q<enter> before typing mysqldump ;^)
> Any help would be awesome!
> Thank you,
> Tried & Wrong
> mysqldump -u root -ppassword test > test.sql
> mysqldump -u root -ppassword test > test.sql;
> mysqldump -u root -ppassword -databases test >
> Yahoo! oneSearch: Finally, mobile search
> that gives answers, not web links.
> 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.
+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.