Skip to main content


Help needed. *sigh*

I'm trying to back up my #Friendica instance on #Yunohost. Installed version should be the latest: 2022.12

I get error messages, both via web and CLI:

Info: Backing up the MySQL database...
Warnung: mysqldump: Error 1412: Table definition has changed, please retry transaction when dumping table `workerqueue` at row: 0


Anyone out there been able to solve this? There doesn't seem to be a solution on https://github.com/YunoHost-Apps/friendica_ynh/issues or maybe I'm just missing it.

Thanks in advance.

@Friendica Admins

in reply to zeitverschreib [friendica]

We are constantly optimizing some tables, including this one. You could deactivate this on the admin backend. But then you should optimize the tables by yourself every few days.
in reply to Michael Vogel

@Michael Vogel

Following the info on https://github.com/friendica/friendica/issues/11822, I was able to successfully run a backup in maintenance mode. May have been a coincidence, but I will try it again tomorrow.
in reply to Michael Vogel

@Michael Vogel @zeitverschreib [friendica] like running mysqlcheck -o -A ?

Also I guess you could disable php-fpm and nginx for the time you do this work. Maybe manually systemctl stop the services that look like Friendica needs them.

But the solution of @Michael Vogel is better if it works.
in reply to utzer [Friendica]

@utzer [Friendica]

Thanks, I will try those commands the next time. For now, setting the instance to maintenance seems to do the trick.

@Michael Vogel

Lo, thar be cookies on this site to keep track of your login. By clicking 'okay', you are CONSENTING to this.