#!/bin/sh

MYSQLCMD=$(which mysql)

# Read Magento primary connection info
DBHOST=$(/PATH/TO/php -r "echo simplexml_load_file('/PATH/TO/app/etc/local.xml', NULL, LIBXML_NOCDATA)->global->resources->default_setup->connection->host;")
DBUSER=$(/PATH/TO/php -r "echo simplexml_load_file('/PATH/TO/app/etc/local.xml', NULL, LIBXML_NOCDATA)->global->resources->default_setup->connection->username;")
DBPASS=$(/PATH/TO/php -r "echo simplexml_load_file('/PATH/TO/app/etc/local.xml', NULL, LIBXML_NOCDATA)->global->resources->default_setup->connection->password;")
DBNAME=$(/PATH/TO/php -r "echo simplexml_load_file('/PATH/TO/app/etc/local.xml', NULL, LIBXML_NOCDATA)->global->resources->default_setup->connection->dbname;")

$MYSQLCMD -u $DBUSER -p$DBPASS -h $DBHOST $DBNAME