环境:laravel6 + homestead + MySql
配置:config/filesystems.php
'backup' => [
'driver' => 'local',
'root' => base_path('storage'),
'url' => env('APP_URL') . '/storage',
],
控制器声明:
use App\Http\Controllers\Controller;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Config;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Schema;
use Illuminate\Support\Facades\Storage;
use Ifsnop\Mysqldump as IMysqldump;
class BackController extends Controller
{
//
protected $directory = 'backup';
}
备份
public function back(Request $rquest)
{
$table = $request->tablename;
$mysql = Config::get('database.conne