Best way to do a backup for large databases
!Friendica Admins Our database is around 30GB in size and I use the YNH package plus BORG to backup to a remote location. Problem is that midway the database fails to backup because:
2023-08-19 00:35:12,150: WARNING - mysqldump: Error 1412: Table definition has changed, please retry transaction when dumping table inbox-entry
at row: 0
Now I put friendica in maintenance before the backup but that means having it unavailable for 30 minutes while the database is being dumped. Is there a better way?
Thanks! :)
Friendica Admins reshared this.