Download the PHP package arham-solcoders/backupguard without Composer

Laravel DB Backup Package

A publishable Laravel package that creates daily SQL database backups from the host project's database configuration and keeps only the last 3 days of backup files.

Features

• Daily backup command: db-backup:run
• Reads connection settings from host app config/database.php (which comes from host .env)
• Supports MySQL/MariaDB and PostgreSQL
• Prunes backup files older than configured retention (default: 3 days)
• Publishable config file

Requirements

• PHP 8.1+
• Laravel 10/11/12
• System binaries:
  • mysqldump for MySQL/MariaDB
  • pg_dump for PostgreSQL

Installation

The service provider is auto-discovered.

Publish Config

This creates:

• config/laravel-db-backup.php

Configuration

Scheduling

For Laravel 11+, the package uses withSchedule() automatically.

For Laravel 10, add this to your app scheduler:

Cron (Server)

Make sure your server cron runs Laravel scheduler every minute:

Verify

Run manually:

Backups are stored in:

• storage/app/db-backups/{connection-name}/{YYYY-MM-DD}/

Publish This Package (Complete Steps)

1. Create a new GitHub repository for this package.
2. Push code to main.

3. Tag a release:

4. Publish to Packagist:
   • Open https://packagist.org/packages/submit
   • Submit your repository URL
5. In consumer Laravel app:
   • composer require arham-solcoders/backupguard
   • php artisan vendor:publish --tag=laravel-db-backup-config
   • Configure backup path/connections
   • Ensure scheduler cron exists

Troubleshooting

• mysqldump: not found or pg_dump: not found:
  • Install database client tools and ensure they are available in PATH.
• Authentication failures:
  • Verify host app .env DB credentials.
• Empty output:
  • Try command manually with verbose DB credentials to confirm binary access.

License

MIT