Import SQL File To MySQL Database: Laravel Ready Command (cross platform using Symfony Process)

ImportTableWithDataFromSQL.php

<?php

namespace App\Console\Commands;

use Illuminate\Console\Command;
use Symfony\Component\Process\Exception\ProcessFailedException;
use Symfony\Component\Process\Process;

class ImportTableWithDataFromSQL extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'import-table-from-sql {table : table to dump}';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Imports table structure with data from sql file';

    /**
     * Create a new command instance.
     *
     * @return void
     */
    public function __construct()
    {
        parent::__construct();
    }

    /**
     * Execute the console command.
     *
     * @return int
     * @throws \Exception
     */
    public function handle()
    {
        $table = $this->argument('table');

        $targetFile = "database/schema/{$table}.sql";

        if(!file_exists($targetFile)){
            throw new \Exception("File {$targetFile} doesn't exist");
        }

        $this->line("Importing table {$table}");

        $passwordPart = empty(config('database.connections.mysql.password')) ? '' : '-p"${:PASSWORD}"';
        $command = 'mysql -u "${:USERNAME}" -h "${:DB_HOST}" '.$passwordPart.' "${:DB_NAME}" < "${:TARGET_FILE}"';

        // we use cross-platform process factory
        // @see: https://symfony.com/doc/current/components/process.html
        $process = Process::fromShellCommandline($command, null, [
            'USERNAME' => config('database.connections.mysql.username'),
            'PASSWORD' => config('database.connections.mysql.password'),
            'DB_HOST' => config('database.connections.mysql.host'),
            'DB_NAME' => config('database.connections.mysql.database'),
            'TARGET_FILE' => $targetFile
        ]);

        $this->line( json_encode($process->getEnv(), JSON_PRETTY_PRINT) );
        $this->line( $process->getCommandLine() );

        $process->run();

        // if something is wrong we throw an exception
        if (!$process->isSuccessful()) {
            throw new ProcessFailedException($process);
        }

        $this->line($process->getOutput());

        $this->line("table imported from: $targetFile");

        return 0;
    }
}