Migrate tables without content

[IsraelOrtuno]

I wonder if there's any way to migrate tables but without content. Tables like jobs, job_batches, failed_jobs are likely to be marked as excluded but their migration would usually be there so when restoring the backup, these tables won't be created but there will be a record for them in the migrations table which also prevents them from being creating by running php artisan migrate. Same could happen with tables for telescope. I wonder if there's a way to exclude tables data instead.

What I am doing now is as soon as I restore the database, I delete a couple of records in the migrations table and then run the migrations again to get those tables created. Not a big deal but error prone process.

[limenet]

@IsraelOrtuno hope this helps :)

use Spatie\Backup\Events\DumpingDatabase;
use Spatie\DbDumper\Databases\MySql;

Event::listen(function (DumpingDatabase $event): void {
    // for type safety; MariaDb extends MySql
    if (!$event->dbDumper instanceof MySql) {
        return;
    }

    $event->dbDumper->excludeTablesData([
        'cache',
        'pulse_aggregates',
        'pulse_entries',
        'pulse_values',
        'telescope_entries',
        'telescope_entries_tags',
        'telescope_monitoring',
    ]);
});

See also https://github.com/spatie/db-dumper#excluding-tables-from-the-dump and https://github.com/spatie/db-dumper#excluding-table-data-from-the-dump