'mysqldump' is not recognized as an internal or external command

RK26 picture RK26 · Jul 11, 2015 · Viewed 26.5k times · Source

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.

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

Answer

Bhaskar Mohanta picture Bhaskar Mohanta · Nov 29, 2016

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

  1. Open Command Prompt and type this

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

Press Enter

then type

mysqldump.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

mysqldump.exe

It will work 100% correctly