Mysql Export/Import for Laravel

mysql_export_import_for_laravel.txt

use Symfony\Component\Process\Process;
use Symfony\Component\Process\Exception\ProcessFailedException;

//Export
$process = new Process('mysqldump -u'.env('DB_USERNAME').' -p'.env('DB_PASSWORD').' '.env('DB_DATABASE').' > db-backups/'.Carbon::now()->timestamp.'.sql');

//Import (on production add password as well '-p'.env('DB_PASSWORD'))
$process = new Process('mysql -u'.env('DB_USERNAME').' '.env('DB_DATABASE').' '.'< db-backups/1508156934.sql');


$process->run();   // to run Sync
// OR
$process->start(); // Running Processes Asynchronously

// while ($process->isRunning()) {
        
// }


// executes after the command finishes
if (!$process->isSuccessful()) {
  throw new ProcessFailedException($process);
}

return $process->getOutput();