#!/bin/bash
cat << EOF > subwebsites.list
subsite1
subsite2
subsite3
subsite4
EOF

BASEPATH="/var/www/html"
CLIENTFOLDER="mainsite"
CLIENTNAME="WHOAREYOU"

rm -rf $PWD/$CLIENTNAME-mysql-dumps
mkdir $PWD/$CLIENTNAME-mysql-dumps
for line in $(cat subwebsites.list)
do
        mkdir $PWD/$CLIENTNAME-mysql-dumps/$line
        DBNAME=`grep DB_NAME $BASEPATH/$CLIENTFOLDER/$line/wp-config.php | cut -d \' -f 4 | tail -n 1`
        DBUSER=`grep DB_USER $BASEPATH/$CLIENTFOLDER/$line/wp-config.php | cut -d \' -f 4 | tail -n 1`
        DBPASS=`grep DB_PASSWORD $BASEPATH/$CLIENTFOLDER/$line/wp-config.php | cut -d \' -f 4 | tail -n 1`
        touch $PWD/$CLIENTNAME-mysql-dumps/$line/db_infos.txt
        echo "$DBNAME" > $PWD/$CLIENTNAME-mysql-dumps/$line/db_infos.txt
        echo "$DBUSER" >> $PWD/$CLIENTNAME-mysql-dumps/$line/db_infos.txt
        echo "$DBPASS" >> $PWD/$CLIENTNAME-mysql-dumps/$line/db_infos.txt
        mysqldump $DBNAME > $PWD/$CLIENTNAME-mysql-dumps/$line/$DBNAME.sql
done
MAINDBNAME=`grep DB_NAME $BASEPATH/$CLIENTFOLDER/wp-config.php | cut -d \' -f 4 | tail -n 1`
mysqldump $MAINDBNAME > $PWD/$CLIENTNAME-mysql-dumps/$MAINDBNAME
echo -e "All your websites and subwebsites databases are dumped in the $CLIENTNAME-mysql-dumps"
echo -e "with also an index containing original database name, user and password for each"
echo -e "This script was coded to be used with sql-mass-importer.sh"