Snippet for updating links in wordpress on docker setup

gistfile1.txt

#!/bin/bash

echo param is $1


# DUMPING A TABLE
MYSQL=c-mysql
CLI=i-mysql-cli
HOSTPATH=/srv/wp-mu/data/mysql
DOCKERPATH=/mnt/data

ADMIN_PASSWORD=$( docker logs $MYSQL 2>&1 | grep "    mysql -uadmin" | awk '{print $3}' | cut -c 3- )
IP=$(docker inspect $MYSQL | grep IPAddress | cut -d '"' -f 4)
echo $IP
echo $ADMIN_PASSWORD


SCHEMA=wp-mu
TABLE=wp_10_posts

#exit
docker run -rm -t -i -v  $HOSTPATH:$DOCKERPATH:r $CLI /usr/bin/mysqldump -h $IP -u admin --password=$ADMIN_PASSWORD $SCHEMA $TABLE > table.sql

#cat table.sql | sed  's:hackdeoverheid.nl/wp-content/uploads/: LEXIO :g' > lexio.sql
cat table.sql | sed  's:hackdeoverheid.nl/wp-content/uploads/:hackdeoverheid.nl/wp-content/uploads/sites/10/:g' > newtable.sql

docker run -rm -t -i -v  $HOSTPATH:$DOCKERPATH:r $CLI /usr/bin/mysql -h $IP -u admin --password=$ADMIN_PASSWORD $SCHEMA  < newtable.sql

[3:04] 
dit is de code om http links te veranderen in mysql