Risoluzione problemi
Risolvere: Fix Max Allowed Packet Backup Export
Cause e fix per « Max Allowed Packet Backup Export » nei backup Multisite.
Gratuito
Fix per Fix Max Allowed Packet Backup Export
When you hit max allowed packet backup export, start with the Multisite Migrate job log: last completed chunk, PHP/memory messages, HTTP 502/504, disk/inode errors, or cloud auth failures. Multisite archives are larger and table-heavier than single-site jobs, so shared hosts interrupt long PHP requests — Jobs in Chunks exist specifically for that.
Check tmp/disk free space, upload_max_filesize for imports, S3/Drive/Dropbox/SFTP credentials for Plus uploads, and security plugins that block admin-ajax. After restore issues, verify siteurl/home, rewrite rules, domain mapping (sunrise.php), object-cache drop-ins, and CDN caches. Reproduce once on Staging before changing production limits.
Diagnosi dal log per «Max Allowed Packet Backup Export»
Separate backup failures from post-restore URL/media/login problems. Capture job percent, last log line, HTTP status, hosting class, and whether a local archive already exists. That evidence decides whether you raise PHP limits, free disk, fix cloud auth, or only re-upload.
For “max allowed packet backup export”, avoid restarting from scratch if a chunked job can resume. Lost locks, cleared tmp, or a new job ID are common reasons a progress bar jumps back to 0%.
Fix allineati alla realtà Multisite
Raise PHP time/memory enough for safety, but keep chunked jobs — shared hosts can still kill long workers. Free disk and inodes before large network archives. Allow admin-ajax through WAF or security plugins. On Plus, re-test Drive/Dropbox/S3-compatible/SFTP credentials and quotas.
Free handles core backup/restore; Plus covers BYO cloud; Pro covers remote import, empty-server installer, Staging, and split/extract. Pick the tool that matches the failure — do not upgrade tiers hoping a cloud auth typo will disappear.
Dopo che l’archivio è completo
If the local archive is good, you can restore even when cloud upload failed. Fix destination auth/quota, then re-upload, or restore from local. On Staging, confirm HTTPS, mapping, media, and logins before production.
If mid-restore failed, do not “fix” production DNS first — finish Staging validation and confirm table/prefix expectations.
Retention, cifratura e igiene support
For fix max allowed packet backup export, keep enough archive generations to roll back a bad deploy or failed migration. Optional .venc AES-256 encryption on Multisite Migrate archives protects copies at rest when you store offsite on Plus destinations. Document credentials, schedule windows, and who may run Network Admin jobs.
Separate schedule failures from restore failures in your runbook so on-call staff do not rebuild a finished archive unnecessarily.
Perché conta
Diagnosi dai log
Capite se l’errore è PHP, disco, DB, cloud o rewrite URL.
Jobs in chunks come fix predefinito
Riprendere invece di riavviare da zero job Multisite enormi.
Check lato restore
Separa fallimenti backup da problemi URL/media/login post-restore.
Prove pronte per il support
Sapere quali righe di log e fatti ambiente catturare per il support.
Passi
-
1Catturare il punto di errore
Eseguite questo passo in Network Admin o sul subsite e verificate su Staging.
-
2Applicare il fix corretto
Eseguite questo passo in Network Admin o sul subsite e verificate su Staging.
-
3Rieseguire in chunks
Eseguite questo passo in Network Admin o sul subsite e verificate su Staging.
-
4Confirm local archive integrity (localizzato)
Eseguite questo passo in Network Admin o sul subsite e verificate su Staging.
-
5Validare il percorso restore
Eseguite questo passo in Network Admin o sul subsite e verificate su Staging.
Domande frequenti
Risposte rapide su questo tema Multisite. Ancora bloccato? Apri i docs o contatta il support.
Domanda: Should I raise PHP limits forever?
Risposta Multisite Migrate: Free/Plus/Pro, job in chunks, cloud BYO e drill di restore in Staging.
Domanda: Why did the job restart at 0%?
Di solito lock perso, tmp svuotato o nuovo job ID. Controlla lock e disco prima di rieseguire.
Domanda: Cloud upload failed but local archive exists?
Sistema auth/quota destinazione, poi ricarica — o restaura dall’archivio locale.
Domanda: Is “max allowed packet backup export” usually backup or restore?
Risposta Multisite Migrate: Free/Plus/Pro, job in chunks, cloud BYO e drill di restore in Staging.