to run mysql command in sql editor like toad or sql yog

[red brick]

HI
I want to know how to run mysql command in sql editor like toad or sql yog.

This is because i want to take back up tables in a database without using any

external tool. so i want to use mysqldump command.

I am using the command following way in query editor but it is showing error

here database= department
table= dept


mysqldump -u root -p password department dept > dept.sql;


Error - MySQL Database Error: 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 'mysqldump -u root -p secret sms_settings > sms.sql' at line 1 1 0

WHEN I AM USING THIS IN MYSQL COMMAND PROMPT THEN ALSO IT IS SHOWING ERROR

mysql> mysqldump -u root -p password department dept > dept.sql;

The error that is coming error 1064(42000) you have an error in your sql syntax.


how should i give the path . It is showing error for backslashes(\) or may
for any special characters; Is the file stored in a default directory. If so what is that.