Skip to content

Instantly share code, notes, and snippets.

@lukecav
Last active July 30, 2025 10:07
Show Gist options
  • Save lukecav/f333618818b2be33bb8ff96a0d90faac to your computer and use it in GitHub Desktop.
Save lukecav/f333618818b2be33bb8ff96a0d90faac to your computer and use it in GitHub Desktop.

Revisions

  1. lukecav revised this gist Sep 26, 2022. 1 changed file with 4 additions and 1 deletion.
    5 changes: 4 additions & 1 deletion Commands
    Original file line number Diff line number Diff line change
    @@ -2,4 +2,7 @@
    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
    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
  2. lukecav revised this gist Jan 7, 2019. 1 changed file with 3 additions and 0 deletions.
    3 changes: 3 additions & 0 deletions Commands
    Original file line number Diff line number Diff line change
    @@ -1,2 +1,5 @@
    # 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
  3. lukecav revised this gist Jan 7, 2019. 2 changed files with 2 additions and 1 deletion.
    1 change: 0 additions & 1 deletion Command
    Original file line number Diff line number Diff line change
    @@ -1 +0,0 @@
    wp db export /wp-content/wordpress-dump.sql --all-tablespaces --single-transaction --quick --lock-tables=false
    2 changes: 2 additions & 0 deletions Commands
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,2 @@
    wp db export /wp-content/wordpress-dump.sql --all-tablespaces --single-transaction --quick --lock-tables=false
    gzip wordpress-dump.sql
  4. lukecav created this gist Jan 7, 2019.
    1 change: 1 addition & 0 deletions Command
    Original file line number Diff line number Diff line change
    @@ -0,0 +1 @@
    wp db export /wp-content/wordpress-dump.sql --all-tablespaces --single-transaction --quick --lock-tables=false