spatie / laravel-backup

A package to backup your Laravel app
https://spatie.be/docs/laravel-backup
MIT License
5.61k stars 758 forks source link

Backup laravel pulse tables #1771

Closed PankovAlxndr closed 5 months ago

PankovAlxndr commented 5 months ago

I use the laravel-backup for backing up the database, here's the command executed via cron backup:run --only-db --only-to-disk=s3-backup.

Everything is fine, backups exist, but when I restore a backup I get this error: ERROR 3105 (HY000) at line 1116: The value specified for generated column 'key_hash' in table 'pulse_aggregates' is not allowed.

Interestingly, when I do the backup manually, like this: mysqldump --no-tablespaces --opt --user=.... --password=... ... | gzip > /var/www/...../prod.sql.gz, there are no problems.