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.
Subject
Written By
Posted
to run mysql command in sql editor like toad or sql yog
April 14, 2011 12:13AM
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.