Mysqldump syntax error

[renesis]

Hi all!
I was wondering what I miss out below in mysqldump syntax

mysql> mysqldump -u root -p dbaseName >file.sql;

or

mysql> mysqldump -u root dbaseName >file.sql;

I connect as "root" and tehre is no password.
In both cases I get errors.
Thanks!

[NogDog]

What errors do you get?

[renesis]

Right, in case someone is wondering, I figured this out. Mysqldump is standalone and shouldn't be runing inside mysql.
Cheers.

[kris44u]

Hi all!
I was wondering what I miss out below in mysqldump syntax

mysql> mysqldump -u root -p dbaseName >file.sql;

or

mysql> mysqldump -u root dbaseName >file.sql;

I connect as "root" and tehre is no password.
In both cases I get errors.
Thanks!


Hello,

mysqldump is standalone application,
so go C:\Program Files\MySQL\MySQL Server 5.0\bin folder
copy the path
past in command prompt
type

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump -uroot -p directorymaps >a.sql
Enter password:

now it will work, i am sure
#
Open the Command Line utility by Clicking on 'Start' and 'Run' and typing 'CMD' and pressing 'ok'
#
Type 'mysqldump'
#
Type -u and your username '-uusername'
#
Type -p and your password '-ppassword'
#
Type your database name 'mydatabase'
#
Type a greater-than sign to put the results in to a file '>'
#
Type the name of the file to put the results in 'mybackupfile.sql