mysql - mysqldump command not working?

Question

I am using mysqldump to take backup of my database, but the command is not working.. the command i am using is mysqldump -u root dbname> 'c:ackupdatafolderackup.sql' i am running this command in MySQL cli but not running,..is there any thing wrong in the command?

Answer 1

You are supposed to run that on the command line of your operating system not on the MySQL CLI.

cd to the bin folder of MySQL first, something like C:mysqlin or wherever your MySQL is installed on

Answer 2

The solution I found is adding MySQL's installation directory to PATH

Steps:

1 - Find where MySql is installed

2- Add the bin directory of MySql installation to PATH

(In the terminal),

 locate mysqldump

export PATH=$PATH:MY_SQL_INSTALLATION_DIRECTORY/bin

MY_SQL_INSTALLATION_DIRECTORY is the directory you found by locate mysqldump: Example

export PATH=$PATH:/usr/local/mysql-5.6.23-osx10.8-x86_64/bin

Now check one more time, I hope its fixed