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

Question

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

Carbonize

Open a new command window. Type set. Look at path. Was it updated? Type mysqldump – Overall

Yes, it is updated, But, when i type mysqldump, i got the same message. ('mysqldump' is not recognized as an internal or external command, operable program or batch file.) – Carbonize

Cd c:\ then dir mysqldump.exe /s – Overall

The system cannot find the path specified. – Carbonize

These guys have it https://mcmap.net/q/666095/-dump-matching-tables-php – Overall

Looks like you haven't installed mysqldump – Bedel

I thought xampp already have mysqldump in it – Carbonize

Answer 1

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

Palatable

saved me a lot of time! – Brainard

Answer 2

If you are using Xamp then:

1. Open your Xamp folder
2. Go to \mysql\bin find the mysqldump.exe
3. Go to your environment variables under System variable click on 'New'.
4. As 'variable name' put 'mysqldump'(without the quotes) and as 'variable value' put the path to your xamp\mysql\bin\mysqldump.exe this will make 'mysqldump' available as a global system alias.

Reminder: Make sure to restart your command-line interface.

Oe

For Windwos 10: Control Panel\System and Security\System > Advanced system settings > Environment Variables (from Nick's comment to answer https://mcmap.net/q/341982/-how-to-access-the-command-line-for-xampp-on-windows) – Xena

In my case, I had to edit System Variables -> Path, then add it. If you just add it to System Variables, it might not work. – Fire

Answer 3

On my side, I was using PowerShell and I had the same error message. I had to go inside the directory of MySql. Mine was located in:

C:\Program Files\MySQL\MySQL Server 5.7\bin

Then I had to make sure that I had mysqldump.exe in the bin folder.

And then run this command:

 ./mysqldump.exe -u root -p yordbName > C:\MySqlDump\sakila.sql

Nork

Answer 4

It happened with me and I solved it by adding the following line at the top of the .bat file.

cd "C:\xampp\mysql\bin"

Grenoble

OP is not using a windows batch file but PHP/Laravel. – Haffner

Answer 5

Please add C:\xampp\mysql\bin to this path at your user variables and system variables. If you are using a wamp server, add C:\wamp64\bin\mysql\mysql8.0.27\bin this path at your user and system variables.

Note: MySQL version path will change as per your installation.

Anallise

Answer 6

It is late, but I will answer to this question for other people who have the same issue.

You need to add the mysqldump.exe runtime file path to your Windows environment variable. I am using Wamp, the path look like this "C:\wamp64\bin\mysql\mysqlx.x.xx\bin"

Close your command-line interface and try again, It should work.

Spanish

Answer 7

I am using Xamp and the following step is working:

Copy the path "C:\xampp\mysql\bin" Go to your environment variables under System variable click on 'Path' and add "New". Put the path there then click ok. Restart your command-line interface.

Disconcert

OP explicity stated that he has already tried this. – Haffner