Skip to content

Instantly share code, notes, and snippets.

@matusmarcin
Last active November 26, 2017 22:14
Show Gist options
  • Save matusmarcin/cbf6087d7cb473c3dc359cf9943b49a4 to your computer and use it in GitHub Desktop.
Save matusmarcin/cbf6087d7cb473c3dc359cf9943b49a4 to your computer and use it in GitHub Desktop.
My WP deployment script (runs on a server)
#!/bin/bash
MYSQLPWD='PWD-HERE-BECAUSE-I-AM-LAZY-TO-DO-BETTER'
echo "> "
echo "> I am about to deploy citajmesispolu.sk!"
echo "> "
read -p ">>> Press enter to continue..."
cd /mnt/v3-citajmesispolu/www && pwd
echo "> "
echo "> Will backup now and fetch..."
echo "> "
echo "> "
echo "> Backing up."
echo "> "
rm -rf ../www-backup/* && cp ./ ../www-backup -R
echo "> "
echo "> Pulling from git."
echo "> "
git fetch --all
git reset --hard origin/master
cp ../config/wp-config.php ./
echo "> "
echo "> Generating date-based DB backup."
echo "> "
mysqldump -u citajmesispolu -p$MYSQLPWD citajmesispolu > ../db-backup/$(date +%Y-%m-%d-%H.%M.%S).sql
# For compressed file: | bzip2 -c > <backup>$(date +%Y-%m-%d-%H.%M.%S).sql.bz2
# Place it into ../db-backup/2017-11-26-21-56-07.sql
echo "> "
echo "> Will import latest.sql from git..."
echo "> "
mysql -u citajmesispolu -p$MYSQLPWD -D citajmesispolu < _db-dumps/latest.sql
echo "> "
echo "> Will update site URL in DB just in case..."
echo "> "
mysql -u citajmesispolu -p$MYSQLPWD -D citajmesispolu < ../config/update-site-url.sql
echo "> "
echo "> DONE."
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment