#!/bin/bash
CONFIG=`find . -name wp-config.php -maxdepth 2 | head -n 1`
if [ ! -f $CONFIG ]; then
echo "Could not find wp-config in this folder or one folder deep."
exit 3
fi
DB_NAME=`echo "<?php include '${CONFIG}'; echo DB_NAME;" | php`
DB_USER=`echo "<?php include '${CONFIG}'; echo DB_USER;" | php`
DB_PASS=`echo "<?php include '${CONFIG}'; echo DB_PASSWORD;" | php`
DB_HOST=`echo "<?php include '${CONFIG}'; echo DB_HOST;" | php`
DUMP_PATH=db.sql
## Alternate name with database name and date:
#DUMP_PATH=${DB_NAME}-$(date +%Y%m%d).sql
echo -n "Dumping database to ${DUMP_PATH}... "
mysqldump --user=${DB_USER} --password=${DB_PASS} --host=${DB_HOST} \
--databases ${DB_NAME} \
> ${DUMP_PATH}
if [ "$?" -ne "0" ]; then
echo "DB dump failed."
exit 1
fi
echo "Done"
exit $?