Mysql query does not work

@sinnbeck syntax error

Are you running it on a an ubuntu shell? Or windows commandline?

You can try going to the directory first to see if that works

cd C:\Users\Amir\Desktop\package\storage\app\sql-tmp\db-dumps
mysql -u root -p test < mysql-test.sql

@sinnbeck I'm running on Windows command line. Note that I'm running this query with DB::statement()

You can't use php in a SQL file just pure SQL and PL/SQL.

@isamirsalehi How are you running it with DB::statement() ? Where did you put that?

@sinnbeck I wanna run a MySQL query inside PHP code (That's not a PHP pure code). Does Laravel have any way to run that?

@tray2 Yeah I know that, thanks.

@tray2 it's restoring a backup file

Then you should not use any php at all. just run a sql backup like @sinnbeck said and you should be good. Or use the batabase program of your choice to run it.

So if you have edited your backup file remove all the changes you made.

@tray2 Let me explain to you what am I doing exactly. I'm writing a package that when you fresh your migrations, it takes a backup of your database before fresh command runs, and at the end of the freshing migrations, it restores all the data. So your data is still in the tables.

this is the repository of the package and I committed the last changes. If it's possible for you please check it out and help me with what to do with it. https://github.com/iamamirsalehi/laravel-save-fresh

DB::statement("mysql {$database['user']} {$database['pass']} {$database['db_name']} < '{$database['sqlFile']}'");

//try instead
$process = \Symfony\Component\Process\Process::fromShellCommandline("mysql {$database['user']} {$database['pass']} {$database['db_name']} < '{$database['sqlFile']}'");
$process->run();

https://symfony.com/doc/current/components/process.html

@sinnbeck thank you so much, It works but the data didn't return to the database

add

if (!$process->isSuccessful()) {
    throw new ProcessFailedException($process);
}