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

Does this package support backup of dynamic fields #1769

Closed lengjunbin-trec closed 6 months ago

lengjunbin-trec commented 6 months ago

I have a virtual column that dynamically generated。 when I try to import the database via backup sql.it show me error ERROR 3105 (HY000) at line 1828: The value specified for generated column 'RemoteUserIdMakerHashed_2' in table 'Users' is not allowed.

this field create script is RemoteUserIdMakerHashed json NOT NULL DEFAULT (json_object()), RemoteUserIdMakerHashed_2 varchar(255) COLLATE utf8mb4_unicode_ci GENERATED ALWAYS AS (json_unquote(json_extract(RemoteUserIdMakerHashed,_utf8mb4'$."2"'))) VIRTUAL,