Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
3.7k views
in Technique[技术] by (71.8m points)

mysql - mysqldump command not working?

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?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

2 Answers

0 votes
by (71.8m points)

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


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
0 votes
by (100 points)
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
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

2.1m questions

2.1m answers

60 comments

57.0k users

...