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
>
>
