Laravel 10 Daily Weekly Monthly Automatic Database Backup
In this post, we will learn laravel 10 database backup daily. Here you will learn laravel 10 database weekly backup. step by step explain laravel 10 database monthly backup. step by step explain laravel 10 automatic database backup. So, let's follow a few steps to create an example of automatic database backup in laravel 10.
Sometimes we work on large websites with important data. so we most of the need to take database backup every day, weekly or monthly. so we must need to cron schedule to get database backup. here I will give you step-by-step instructions on how to create an automatic DB backup in laravel.
In this example, we will create a database:backup and we will schedule daily this command to run. this command will take a backup of the database and put it into the storage folder.
Let's follow few step and set auto daily database backup using laravel.
Step 1: Install Laravel
In this step, if you haven't laravel application setup then we have to get a fresh laravel application. So run the below command and get a clean fresh laravel application.
composer create-project laravel/laravel blog
Step 2: Create Command
In this step, we will create DatabaseBackUp console command using laravel artisan command. so let's run bellow command:
php artisan make:command DatabaseBackUp
Now they created DatabaseBackUp.php file on console directory. so let's update that file with daily update code.
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 = 'Command description';
* Execute the console command.
public function handle(): void
$filename = "backup-" . now()->format('Y-m-d') . ".gz";
$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);
Step 3: Create Backup Folder
In this step, we need to create "backup" folder in your storage folder. you must have to create "backup" on following path:
Make sure you give permission to put backup file.
Step 4: Schedule Command
Now, in this step, we need to schedule our created command. so let's update kernel file as like bellow:
use Illuminate\Foundation\Console\Kernel as ConsoleKernel;
class Kernel extends ConsoleKernel
* Define the application's command schedule.
protected function schedule(Schedule $schedule): void
* Register the commands for the application.
protected function commands(): void
you can check manually with following command to getting database backup with this command:
php artisan database:backup
It will create one backup file on your backup folder. you can check there.
Setup on Server:
Now, we are ready to setup cron on our server.
At last you can manage this command on scheduling task, you have to add a single entry to your server’s crontab file:
Run following command:
You can add following line to your crontab file. you have to change folder path.
* * * * * php /path/to/artisan schedule:run 1>> /dev/null 2>&1
* * * * * cd /path-to-your-project && php artisan schedule:run >> /dev/null 2>&1
I hope it can help you...
We are Recommending you
- Laravel 10 CRUD with Image Upload Tutorial
- Laravel 10 Create RSS Feed Example Tutorial
- Laravel 10 Generate Sitemap XML File Tutorial Example
- How to Merge Multiple PDF Files in Laravel 10?
- Laravel 10 Image Intervention Tutorial With Example
- Laravel 10 Autocomplete Search from Database Example
- Laravel 10 Google Recaptcha V3 Example Tutorial
- Laravel 10 Google Charts Tutorial Example
- Laravel 10 Fullcalendar Ajax Tutorial Example
- Laravel 10 Multiple Database Connections Example
- Laravel 10 Summernote Editor with Image Upload
- Laravel 10 Stripe Payment Gateway Integration Tutorial
- Laravel 10 Import Export Excel and CSV File Tutorial
- Laravel 10 Generate PDF File using DomPDF Example