L. Arnold's picture

My experience with Magento (not consistently yet) but it has worked is that it is best to first

increase your max_allowed packet

then

TKLBAM-restore XX --skip-database

then,

TKLBAM-restore XX --skip-files --skip-packages

then,

Change your IP to a Public IP

then,

Restart  (not at the first prompting after first restore)

---

Failing this, where I am now, It is also worth Manually Backing Up Databases, then Manually Restoring them.  I understand PostGres Databases need to be treated this way right now as well.

Sometimes it is a specific Database or Set of Databases causing the problem (log files for instance) that you may need to exclude.  The error of broken Pipe will point to one Database but the last time I saw the error it was in fact the Database right before it that broke the Pipe.  These really were not huge data files either... but bigger than the rest to be sure.