Backup Pages - Error reading from database

Backup Pages - Error reading from database

by Russell Thomson -
Number of replies: 2

2.9.5+

I been trying to reconstruct my database as something went really wrong with the last one. I tried backing up pages and received the following error message. Can anyone help to correct it?

Regards

Attachment Screenshot 2016-06-15 11.27.58.png
Average of ratings: -
In reply to Russell Thomson

Re: Backup Pages - Error reading from database

by Ken Task -
Picture of Particularly helpful Moodlers

'Server has Gone Away' refers to the DB server.   It is a known issue and has to do with the DB servers or client config settings for a DB server/client  variable called  'max_packets_allowed'.   Moodle trying to send a lot of data in one chunk.   For initial DB server setups that uses default 16M which is too small for certain Moodle processes ... backups/restores.   Increase the value to 32M and restart MySQL server for changes to take affect, then try whatever again.

See: https://dev.mysql.com/doc/refman/5.5/en/packet-too-large.html for tech info.

Now am curious as to why 're-construct'ion is needed and what that really means.   Heard of restoring an sql dump before but never 're-construction of'.   And what was this 'terribly wrong' thing about?

'spirit of sharing', Ken