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/[EMAIL PROTECTED] > > > -- > 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
