Importing large tables and Jetpack backups over 2 GB fail

[mgozdis]

Quick summary

A user is attempting to import a Jetpack backup into Studio, which is ~3.7GB. It fails on various tables. Some of them are large with over 1 million rows. When I remove the tables it's failing on from the backup, .zip, and attempt to import again, it returns ERR_FS_FILE_TOO_LARGE and appears to have a 2 GB limit. This warning isn't displayed with the original tarball though, which logs similar errors as below but for specific tables it fails on.

Additionally, attempting to only import the database dump, which is ~1.6GB fails with:

[2025-01-11T16:18:55.437Z][erro][main] Warning during import of /var/folders/tv/2__tfdjn4r7252t_xdg4_kj00000gn/T/studio_backupF5cgqw/backup_db.sql: wp-cli command canceled
[2025-01-11T16:18:55.447Z][erro][main] Error occurred in handler for 'importSite': Error: Database import failed
    at t.SQLImporter.<anonymous> (/Applications/Studio.app/Contents/Resources/app.asar/.webpack/main/index.js:2:2388219)
    at Generator.next (<anonymous>)
    at o (/Applications/Studio.app/Contents/Resources/app.asar/.webpack/main/index.js:2:2386920)

User report: 9260467-zd-a8c

Steps to reproduce

1. Start Studio app
2. Select an existing site
3. Select Import/Export
4. Attempt to import a large database dump or large Jetpack backup

What you expected to happen

The backup to import.

What actually happened

Import process is canceled.

Impact

Some (< 50%)

Available workarounds?

No and the app is unusable

Platform

Mac Silicon

Logs or notes

No response

[github-actions]

Support References

This comment is automatically generated. Please do not edit it.

• 9260467-zen

[Robertght]

@wojtekn I'm pinging you since I know your team is on top of this and we're working internally to add this to the One board.