Skip to content

Instantly share code, notes, and snippets.

@jahid32

jahid32/Commands

Forked from lukecav/Commands
Created August 12, 2024 11:44
Show Gist options
  • Save jahid32/702456c2dc9041b4c80f73d2942186cf to your computer and use it in GitHub Desktop.
Save jahid32/702456c2dc9041b4c80f73d2942186cf to your computer and use it in GitHub Desktop.
Download ZIP
Speed up wp db export using WP-CLI
Raw
Commands
# 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