I've read through many people's posts receiving the same error I'm receiving: max_allowed_packets exceeded for my attempts to restore a course.
I followed the advice and increased the value, incrementally up finally all the way to 1000M (a gig). No good at any stop. My overall backup file is only 7.7MB.
So knowing the value is not really the issue, what else might trigger that particular message? We cannot back up (make a copy) of any course--nor restore a course or import a course. Each tells us that we cannot write to the db. However, quizzes, completions, and feedback are all being stored in the DB for active courses. So it's tied somehow to backing up or restoring a (model) past backup.
When I click "restore" and select a backup.mbz file, I see that the content is there (on step 2 of restoration), but I get the Error msg after that.
I've tried several things: I removed any users from one backup, hoping that it was tied to duplicate accounts; I also (as said above), increased the max_allowed_packets size far, far beyond what is reasonable.
Anyone have a suggestion for other things to look into?