Last active
February 7, 2025 08:21
-
-
Save lukecav/f333618818b2be33bb8ff96a0d90faac to your computer and use it in GitHub Desktop.
Speed up wp db export using WP-CLI
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Export site database using wp db export | |
| wp db export /wp-content/wordpress-dump.sql --all-tablespaces --single-transaction --quick --lock-tables=false | |
| # Gzip compress the recent database export | |
| gzip wordpress-dump.sql | |
| # Export sites database using wp db export and gzip compress | |
| wp db export --all-tablespaces --single-transaction --quick --lock-tables=false - | gzip -9 - > wordpress-dump.sql.gz |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Thanks @dustinrue it worked like a charm!