FM / Commands

/home/techb158/ileadtechnology.com/app/Console/Commands/

/home/techb158/ileadtechnology.com/app/Console/Commands

Name	Size	Mode	Actions
DatabaseBackUp.php	1313	0644	edit dl rm
DemoReset.php	8341	0644	edit dl rm
GenerateSitemap.php	680	0644	edit dl rm
ImportDemo.php	3403	0644	edit dl rm
RenameVideo.php	3698	0644	edit dl rm

Edit: /home/techb158/ileadtechnology.com/app/Console/Commands/DatabaseBackUp.php (1313B)

<?php

namespace App\Console\Commands;

use Illuminate\Console\Command;
use File;

class DatabaseBackUp extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'database:backup';

/**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'This Command will create backup of database';

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

/**
     * Execute the console command.
     *
     * @return int
     */
    public function handle()
    {
        $path = 'app/backup/';

if(!file_exists(storage_path().'/'.$path)) 
        {
            $path = 'app/backup/';
            File::makeDirectory(storage_path().'/'.$path,0777,true);
        }

$filename = "backup.sql";
  
        $command = "mysqldump --user=" . env('DB_USERNAME') ." --password=" . env('DB_PASSWORD') . " --host=" . env('DB_HOST') . " " . env('DB_DATABASE') . "  | gzip > " . storage_path() . "/app/backup/" . $filename;
  
        $returnVar = NULL;
        $output  = NULL;
  
        exec($command, $output, $returnVar);

$this->info('Backup Created');
    }
}

" . storage_path() . "/app/backup/" . $filename; $returnVar = NULL; $output = NULL; exec($command, $output, $returnVar); $this->info('Backup Created'); } }