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.
You can get Broken Pipe even increasing max_allowed_packet
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.