1. Go to official link
https://spatie.be/docs/laravel-backup/v8/installation-and-setup
of spatie-backup and copy and run the following command [composer require spatie/laravel-backup]
2. Then copy and run the following command from the same link
[php artisan vendor:publish --provider="Spatie\Backup\BackupServiceProvider"]
3. Now you can include or exclude any file from backup in the config/backup.php file
4. Now in database.php file go to 'mysql' code group and add the following line of code after 'engine' => null,
  the code to add::
   'dump' => [
                'dump_binary_path' => 'C:/xampp/mysql/bin/',
            ],
5. Now in terminal run the following command [php artisan backup:run]
6. Now check the storage folder for your backup zipped file
7. Enjoy backup thanks