Dump drupal content files and DB

dump_drupal_content.sh

#!/bin/bash
# Dump Drupal content(files, sites) and MySQL database

HOST_PATH='/var/www/vhosts/';

if [ $1 != '' ] ; then 
	cd $HOST_PATH$1/httpdocs
fi

DUMP_DIRS=''
if [ -d 'files' ]; then
	DUMP_DIRS=' files/'
fi
if [ -d 'sites' ]; then
	DUMP_DIRS=' sites/'
fi

if [ $DUMP_DIRS != '' ]; then
	echo 'Start taring files and sites directories. Please wait, can take several minutes.';
	tar -c --file=../files_sites.tar -g ../files_sites.snar $DUMP_DIRS
fi

# EXAMPLE $db_url = 'mysql://meslunettes:65nlikeh@localhost/velli_meslunettes';
DBN=`cat sites/default/settings.php |grep -e '^$db_url'`;
USER=`echo $DBN | sed "s/.*:\/\/\(.*\):.*/\1/"`;
PASS=`echo $DBN | sed "s/.*:\(.*\)@.*/\1/"`;
HOST=`echo $DBN | sed "s/.*@\(.*\)\/.*/\1/"`;
DB_NAME=`echo $DBN | sed "s/.*\/\(.*\)';/\1/"`;

echo 'Start mysqldumping. Please wait, can take several minutes.';
mysqldump -u $USER --password=$PASS --host=$HOST $DB_NAME > ../$DB_NAME.mysql

echo 'Done.'