XenForo mariadb-dump: Error 1412: Table definition has changed

[karll]

I have an OS cron job that takes a backup of my XF database every day. This has worked flawlessly from the beginning.

However, today the cron job ran into an error which has made me concerned:

mariadb-dump: Error 1412: Table definition has changed, please retry transaction when dumping table xf_thread_view at row: 0
Click to expand...

This seems to imply that the table definition was changed while the backup was running. I believe this could be caused by either an "ALTER TABLE" or a "TRUNCATE" SQL...

Read more

Continue reading...