PHP / Symfony Development Environment with Vagrant and Ansible – BONUS: MySQL

Daniel

13th March, 2017

DEV

As I have received multiple requests now, I decided to make a little bonus for you 😉

It seems like a lot of you preferring MySQL over PostgreSQL. I don’t understand why, but that’s another topic 😉

Simple WordPress Bash Backup Script

Daniel

10th March, 2015

OPS

Hey Guys,

I needed to do some backups of multiple wordpress sites, so I decided to write a backup script especially for wordpress.

#!/usr/bin/env bash
WP_FOLDER=${1}
BACKUP_FOLDER=${2}

if [ -z ${WP_FOLDER} ] || [ -z ${BACKUP_FOLDER} ]; then
	echo "USAGE: ${0} <PATH_WP_INSTALLATION> <BACKUP_FOLDER>"
	exit 1;
fi

mkdir -p ${BACKUP_FOLDER}/{db,wp}

# check if it looks like wordpress installation
WP_CONFIG="${WP_FOLDER}/wp-config.php"

if ! test -f ${WP_CONFIG}; then 
	echo "ERROR: Cannot detect wordpress installation here... Exiting"
	exit 1;
fi

# get the database connection

DB_NAME=$(grep -E "^define('DB_NAME'" ${WP_CONFIG} | cut -d"'" -f4)
DB_USER=$(grep -E "^define('DB_USER'" ${WP_CONFIG} | cut -d"'" -f4)
DB_PASSWORD=$(grep -E "^define('DB_PASSWORD'" ${WP_CONFIG} | cut -d"'" -f4)
DB_HOST=$(grep -E "^define('DB_HOST'" ${WP_CONFIG} | cut -d"'" -f4)

# doing the backup
mysqldump ${DB_NAME} -u${DB_USER} -p${DB_PASSWORD} -h${DB_HOST} | gzip > ${BACKUP_FOLDER}/db/$(date +%Y%m%d_%H%M)_${DB_NAME}.gz;

if [ $? -ne 0 ]; then
	echo "ERROR: Couldn't dump your database. Check your permissions"
	exit 1;
fi

tar -zcf ${BACKUP_FOLDER}/wp/$(date +%Y%m%d_%H%M).tar.gz  ${WP_FOLDER}/  >/dev/null 2>&1

if [ $? -ne 0 ]; then
	echo "ERROR: Couldn't backup your wordpress directory..."
	exit 1;
fi

#!/usr/bin/env bash

WP_FOLDER=${1}

BACKUP_FOLDER=${2}

if [ -z ${WP_FOLDER} ] || [ -z ${BACKUP_FOLDER} ]; then

echo "USAGE: ${0} <PATH_WP_INSTALLATION> <BACKUP_FOLDER>"

exit 1;

mkdir -p ${BACKUP_FOLDER}/{db,wp}

# check if it looks like wordpress installation

WP_CONFIG="${WP_FOLDER}/wp-config.php"

if ! test -f ${WP_CONFIG}; then

echo "ERROR: Cannot detect wordpress installation here... Exiting"

exit 1;

# get the database connection

DB_NAME=$(grep -E "^define('DB_NAME'" ${WP_CONFIG} | cut -d"'" -f4)

DB_USER=$(grep -E "^define('DB_USER'" ${WP_CONFIG} | cut -d"'" -f4)

DB_PASSWORD=$(grep -E "^define('DB_PASSWORD'" ${WP_CONFIG} | cut -d"'" -f4)

DB_HOST=$(grep -E "^define('DB_HOST'" ${WP_CONFIG} | cut -d"'" -f4)

# doing the backup

mysqldump ${DB_NAME} -u${DB_USER} -p${DB_PASSWORD} -h${DB_HOST} | gzip > ${BACKUP_FOLDER}/db/$(date +%Y%m%d_%H%M)_${DB_NAME}.gz;

if [ $? -ne 0 ]; then

echo "ERROR: Couldn't dump your database. Check your permissions"

exit 1;

tar -zcf ${BACKUP_FOLDER}/wp/$(date +%Y%m%d_%H%M).tar.gz ${WP_FOLDER}/ >/dev/null 2>&1

if [ $? -ne 0 ]; then

echo "ERROR: Couldn't backup your wordpress directory..."

exit 1;

All you need is to call the script with two parametes, the first is the folder where your wordpress instance is installed, in my case /var/www/example.com.
The second is the folder where to backup it.

So for example:
./backup_wordpress /var/www/example.com /tmp/backup/example.com

That’s all, the script figures out how to connect to the database, creates a gzipped dump with timestamp, and creates a tar archive also with a timestamp.

You’ll find it in your specified folder under wp and db.

That’s it, have fun.

Quick and dirty MySQL Backup

Daniel

14th January, 2015

OPS

When you just need a simple backup of all your databases, this three lines do the job for you.

Just save it to a file and run it as a cron every night
00 01 * * * /srv/scripts/mysql_backup
and you get a zipped dump of every database with a timestamp.

It is easy extendable, if you want to exclude a database just write it into the grep regex
grep -Ev "(information_schema|performance_schema|another_database)"

Have fun! 🙂