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/[EMAIL PROTECTED]

Reply via email to