无法将"mysqldump"识别为内部或外部命令 [英] 'mysqldump' is not recognized as an internal or external command

问题描述

目前，我正在尝试在laravel项目中备份和还原mysql数据库.我正在使用此laravel软件包 https://github.com/backup-manager/laravel 进行备份包裹.我已经按照指示执行了，但是当我在最后一个问题中尝试通过命令行(php artisan db:backup)备份本地数据库时，收到了此消息.

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.

Dumping database and uploading...   

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

我已经在使用它，并且已经将C:\ xampp \ mysql \ bin放入我的Windows env变量路径，但是我仍然遇到这个问题.如果有人知道如何解决此问题，请告诉我，我非常感谢.

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.

Laravel 5.1.x

Laravel 5.1.x

推荐答案

这是因为在该位置未找到 mysqldump.exe ，下面给出了正确的路径

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

1. 打开命令提示符，然后输入

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

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

按Enter

然后输入

mysqldump.exe

mysqldump.exe

或

直接打开此目录"C:\ Program Files(x86)\ MySQL \ MySQL Server 5.5 \ bin"，然后从键盘上按左移键，然后在目录窗口上按一下右键.然后输入

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

mysqldump.exe

mysqldump.exe

它将100％正确地工作

It will work 100% correctly

这篇关于无法将"mysqldump"识别为内部或外部命令的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！