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.

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"