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]