mysql到s3_Laravel 5.6-将MySQL数据库备份到S3?

我尝试将整个MySQL数据库备份到S3,如下所示:

namespace App\Console\Commands;

use Carbon\Carbon;

use Illuminate\Console\Command;

use Illuminate\Support\Facades\Storage;

use Symfony\Component\Process\Process;

class DatabaseBackup extends Command {

/**

* The name and signature of the console command.

*

* @var string

*/

protected $signature = 'backup:database';

/**

* The console command description.

*

* @var string

*/

protected $description = 'Take a backup of the entire DB and upload to S3.';

/**

* Create a new command instance.

*

* @return void

*/

public function __construct()

{

parent::__construct();

}

/**

* Execute the console command.

*

* @return mixed

*/

public function handle()

{

$date = Carbon::now()->format('Y-m-d_h-i');

$user = env('DB_USERNAME');

$password = env('DB_PASSWORD');

$database = env('DB_DATABASE');

$command = "mysqldump --user={$user} -p{$password} {$database} > {$date}.sql";

$process = new Process($command);

$process->start();

while ($process->isRunning()) {

$s3 = Storage::disk('s3');

$s3->put('gallery-app-db/' . $date . ".sql", file_get_contents("{$date}.sql"));

unlink("{$date}.sql");

}

}

}

但跑步时

php artisan backup:database

然后查看bucket.sql文件,并在本地下载.sql文件,它显示如下,而不是文件中的实际数据库/表:

知道如何让.sql dump实际工作并备份真正的数据库及其所有表,而不是使用文件吗?