Level 33
make sure you are running Laravel 8.x
its working in Laravel 8.x
php artisan -V
php artisan schema:dump
Sep 23, 2020
6
Level 1
schema:dump Not working
I am trying to run the command. I am getting this error.
php artisan schema:dump
'mysqldump' is not recognized as an internal or external command,
operable program or batch file.
'mysqldump' is not recognized as an internal or external command,
operable program or batch file.
Symfony\Component\Process\Exception\ProcessFailedException
The command "mysqldump --skip-add-drop-table --skip-add-locks --skip-comments --skip-set-charset --tz-utc --host="${:LARAVEL_LOAD_HOST}" --port="${:LARAVEL_LOAD_PORT}" --user="${:LARAVEL_LOAD_USER}" --password="${:LARAVEL_LOAD_PASSWORD}" "${:LARAVEL_LOAD_DATABAS
E}" --routines --result-file="${:LARAVEL_LOAD_PATH}" --no-data" failed.
Level 102
What are you developing on? Server? Docker? Xampp?
Most likely you don't have mysqldump in your $PATH
1 like
Level 6
@Sinnbeck Hi Know that this is an old thread but I wonder if you have a suggestion to to a problem I am having with schema:dump. I do have mysqldump in my path:
mysqldump -V
mysqldump Ver 10.13 Distrib 5.1.63, for apple-darwin10.3.0 (i386)
I get the following error.
Error Output:
================
mysqldump: Couldn't execute 'SET OPTION SQL_QUOTE_SHOW_CREATE=1': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SQL_QUOTE_SHOW_CREATE=1' at line 1 (1064)
My database is running on docker - I think that this might be the issue (although all other artisan db commands work fine) Any ideas as to what I might do to get this working?
Cheers
Level 1
on Xampp. How do i add that?
Level 1
Yes its laravel 8
Level 102
You can try following this guide
https://www.architectryan.com/2018/03/17/add-to-the-path-on-windows-10/
I believe the path is C:\xampp\mysql\bin
1 like
Please or to participate in this conversation.