Introduction

Welcome to our tutorial! Today, In this guide, we’ll walk you through the process of creating a simple yet effective database backup system in Laravel using a custom controller and route. Ensuring that your database is regularly backed up is crucial for maintaining data integrity and recovering from unforeseen events.

Steps

1- Create Controller:

• we will create the controller to write DB backup logic.
• Run following command to create controller.

php artisan make:controller DBBackupController
          

2- Add mysql path in environment variable

Adjust the path according to your xampp mysql\bin path

D:\xampp7.4.30\mysql\bin
          

3- Writting DB backup logic

• Inside the controller add the following code.

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

class DBBackupController extends Controller
{
    public function dbBackupSql()
    {
        $path = public_path('backup');
        $filename = $path . '/' . "backup-" . now()->format('Y-m-d-H-i-s') . ".sql";

        $username = env('DB_USERNAME');
        $password = env('DB_PASSWORD');
        $host = env('DB_HOST');
        $database = env('DB_DATABASE');

        if (!is_dir($path)) {
            mkdir($path, 0777, true);
        }

        $command = "mysqldump --user=" . $username . " --password=" . $password . " --host=" . $host . " " . $database . " > "  . $filename;

        $returnVar = NULL;
        $output  = NULL;

        exec($command, $output, $returnVar);

        return response()->download($filename);
    }
}

          

4- Define the Route:

• Now, we need to define a route that will trigger the backup process. Open your web.php file located in the routes directory and add the following route:

Route::get('db/backup/sql', [DBBackupController::class, 'dbBackupSql'])->name('db.backup.sql');
          

5- Configure Environment Variables:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=your_database_name
DB_USERNAME=your_username
DB_PASSWORD=your_password
          

6- Test functionality:

• Visit the route a check the functionality it should download database backup.

http://your-app-url/db/backup/sql
          

Conclusion

That's it! You have successfully set up the database backup functionality in your Laravel app.

• You can provide a link in your admin panel to manually download the database backup.
• Alternatively, you can set up a cron job to automatically back up the database at specific intervals.