10up / MU-Migration

This WP-CLI plugin makes the process of moving sites from single WordPress sites to a Multisite instance (or vice-versa) much easier. It exports everything into a zip package which can be used to automatically import it within the desired Multisite installation.
MIT License
329 stars 47 forks source link

Unable to Create Zip File With Uploads Option #91

Open ravi-gill opened 3 years ago

ravi-gill commented 3 years ago

Hi there,

We are using the MU-Migration tool to export blogs/sites from a WordPress Multisite instance; however, the export breaks when the uploads directory for the blog/site is too large. For instance, it broke on a blog/site that had just under 700 MB of assets in its uploads directory. Below is the command line we used, and the error we got.

The error mentions QUERY packet so we increased the max_allowed_packet setting on MySQL to the limit allowed but it did not resolve the issue.

How can we resolve this issue?

Thank you

wp mu-migration export all archive.zip --blog_id=61 --uploads --path=/path/to/wp-multisite/htdocs Exporting site meta data... Exporting users... Exporting tables Zipping files.... Warning: Unable to create archive PHP Warning: Error while sending QUERY packet. PID=3481049 in /path/to/wp-multisite/htdocs/wp-includes/wp-db.php on line 2056 Warning: Error while sending QUERY packet. PID=3481049 in /path/to/wp-multisite/htdocs/wp-includes/wp-db.php on line 2056