Bash alias for mysqldump using credentials from a wp-config.php file

wpdump.bash

#!/bin/bash

# one argument: the directory of a wp-config.php file
wpconfig=$1/wp-config.php

if [ ! -f "$wpconfig" ]; then
echo "$wpconfig not found."
exit
fi

db=`sed -n -e "s/^define( *'DB_NAME', *'\([^']*\)'.*/\1/p" < $wpconfig`
if [ -z $db ]; then
echo "Database name not found in $wpconfig."
exit
fi

user=`sed -n -e "s/^define( *'DB_USER', *'\([^']*\)'.*/\1/p" < $wpconfig`
if [ -z $db ]; then
echo "Database user not found in $wpconfig."
exit
fi

pw=`sed -n -e "s/^define( *'DB_PASSWORD', *'\([^']*\)'.*/\1/p" < $wpconfig`
if [ -z $db ]; then
echo "Databaseabase credentials not found in $wpconfig."
exit
fi

mysqldump --user=$user --password=$pw $db

Want --password="$pw" if your password contains spaces :-)