Skip to content

Instantly share code, notes, and snippets.

@bainternet

bainternet/export_database_with_replace.sh

Forked from jan-koch/export_database_with_replace.sh
Created April 18, 2020 13:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save bainternet/90fb2066e32e0034be0d0f320c344be6 to your computer and use it in GitHub Desktop.
Save bainternet/90fb2066e32e0034be0d0f320c344be6 to your computer and use it in GitHub Desktop.
Download ZIP
Bash script to export a database from a WordPress container and perform a search/replace using the UNIX command "sed". Script is based on https://hub.docker.com/r/jankoch/wordpress.
Raw
export_database_with_replace.sh
#! /bin/bash
CONTAINER=$1
SEARCH=$2
REPLACE=$3
# Dump the file
DUMP=$(docker exec $CONTAINER wp db export --add-drop-table --porcelain)
echo "Dump completed. Filename: $DUMP"
# Replace in file
sed -i -e "s/$SEARCH/$REPLACE/g" $DUMP
echo "Search and replace completed"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment