Backup and restore

THANK YOU!!!!!! 

Changing the 'max_allowed_packet' up to 100M did the trick.  All my courses are backing up properly again.

Thanks again, so much!!!

- Shawn

Thanks a lot...

you saved my day.

thanks gunnar

seems to have sorted out my problem as well.  any changes to course settings brought up the 'error writing to database' message.

This solution also worked for me.

Trying to restore an old 1.9 backup, it  gives me an error between step 2 and 3 (so I never saw step 3). The error message changed when I upgraded from plain 2.2 to 2.2+. I'm not 100% shure about those but I think the first was "Coding error detected, it must be fixed by a programmer: PHP catchable fatal error" and the second was "error writing to database". Clearly, the second error message was more accurate.

Increasing max_allowed_packet on the MySQL server removes the problem.

I thought maybe 100M were too much an for me the value of 16M also worked perfectly. I haven't tried any lower value. But be aware that lowering the value too much could affects some backups again.

Maybe a developper can recomend a value and include it somewhere in the documentation.

As the official MySQL Server documentation says:

"It is safe to increase the value of this variable because the extra memory is allocated only when needed."

Reference:

 * http://dev.mysql.com/doc/refman/5.5/en/packet-too-large.html

 * http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_max_allowed_packet

Thank you Gunnar, Your solution worked for me also.