MySQL Forums :: Newbie :: to run mysql command in sql editor like toad or sql yog


Advanced Search

to run mysql command in sql editor like toad or sql yog
Posted by: red brick ()
Date: April 14, 2011 12:13AM

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.

Options: ReplyQuote


Subject Written By Posted
to run mysql command in sql editor like toad or sql yog red brick 04/14/2011 12:13AM
Re: to run mysql command in sql editor like toad or sql yog Barry Galbraith 04/14/2011 12:20AM
Re: to run mysql command in sql editor like toad or sql yog red brick 04/14/2011 12:52AM
Re: to run mysql command in sql editor like toad or sql yog Phillip Ward 04/14/2011 06:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.