“mysqldump”不能识别为内部或外部命令

currently im trying to make backup and restore mysql database in my laravel project. I am using this laravel package https://github.com/backup-manager/laravel for backup package. i already follow the intructions, but when i am trying to backup my local database through command line (php artisan db:backup) in the last question, i got this message.

目前我正在laravel项目中尝试备份和恢复mysql数据库。我正在使用这个laravel包https://github.com/backupmanager/laravel作为备份包。我已经遵循了指示，但是当我试图通过命令行(php artisan db:backup)备份本地数据库时，在上一个问题中，我得到了这条消息。

Dumping database and uploading...   

[BackupManager\ShellProcessing\ShellProcessFailed]
'mysqldump' is not recognized as an internal or external command,
operable program or batch file.

I already googling it, and already put C:\xampp\mysql\bin to my windows env variables paths, but i still having this issue. if anybody know how to fix this, please tell me, i really appreciate it.

我已经google了它，并且已经把C:\xampp\mysql\bin放到我的windows env变量路径中，但是我仍然有这个问题。如果有人知道如何解决这个问题，请告诉我，我真的很感激。

Laravel 5.1.x

Laravel 5.1.x

1 个解决方案

#1

It is because mysqldump.exe is not found in that location, the right path is given bellow

那是因为,mysqldump。exe不在该位置，正确的路径为bellow

1. Open Command Prompt and type this

   cd C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin

   cd C:\Program Files (x86)\MySQL\MySQL Server 5.5 \ bin

Press Enter

按回车键

then type

然后输入

mysqldump.exe

exe

or,

或者,

Directly open this directory "C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin" and Press LEFT SHIFT KEY from keyboard and RIGHT CLICK on the Directory Window. then type

直接打开这个目录“C:\Program Files (x86)\MySQL\ Server 5.5\bin”，按键盘上的左SHIFT键，右键点击目录窗口。然后输入

mysqldump.exe

exe

It will work 100% correctly

它将100%正确地工作