Please add a method to download the dump

[realtebo]

We would like to use this package to dump 2 tables and immediately download it as a file

[vahidalvandi]

also

[CesarObedFL]

also

[freekmurze]

Probably not going to happen, this is out of scope for the package. It's only job is to create a dump, not to interact with the HTTP layer.

[CesarObedFL]

we can move the file generated to a storage/public folder with rename function and then downloaded from there

in your laravel command class

  public function handle()
      {
          $today_date = new \DateTime("now", new \DateTimeZone('America/Mexico_City'));
          $filename = "db_backup_".$today_date->format('Y-m-d').".sql";
  
          MySql::create()
                  ->setDumpBinaryPath( env('DUMP_BINARY_PATH') )
                  ->setDbName( env('DB_DATABASE') )
                  ->setUserName( env('DB_USERNAME') )
                  ->setPassword( env('DB_PASSWORD') )
                  ->setHost( env('DB_HOST') )
                  ->setPort( env('DB_PORT') )
                  ->dumpToFile( $filename );
  
          rename( $filename, 'storage/app/public/database_backups/'.$filename );
      }

in your routes file (web)

Route::get('/download/{file}', function ($file) {
            return Storage::download("public/database_backups/".$file);
        })->name('download');