Skip to main content


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.