MySQL: How To use mysqldump pratically

Hi,

I am runnning MySQL Server v 5.0 on my local machine which has Windows XP Pro SP2 installed.

I have a database "mydb" and I am trying to make use of the mysqldump command since the past 2 days (taking help from mysql.com as well as google)

I have gone through the tutorial http://www.devarticles.com/c/a/MySQL/Backing-Up-Your-MySQL-Databases-With-MySQLDump/

but still unable to see how to make use of it. This is the command I am running in the MySQL Command Line.

mysqldump --host=localhost –-user root –-password=toor mydb > sql.dump

but getting the following error

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'mysql
dump --host=localhost --user root --password=toor mydb > sql.dump' at line 1

Please help

 

do u have phpmyadmin??

 

Yes but I want to know how to make use of mysqldump function.

Dont wanna use phpmyadmin

Thanx

 

mysqldump --host=localhost –-user=root –-password=toor mydb > sql.dump

When using the long commandline options like --user or --host then the = character is used as a seperation.
When using the short commandline options like -u -h then the space is used as a seperation character.
You are using long commandline options but for --user you used the space as a seperation character.

 

that worked like a charm.

Is there any similar command for database restore?

Thanx

 

mysql -uuser -ppassword database < mydatabase.sql

 

Hi

Thats helped.

Thanx