Untitled

#!/bin/bash

# A Simple Script to change the base URLs in a Magento MySQL Database when making a development mirror

MUSER="$1"

MPASS="$2"

MDB="$3"

DOMAIN="$4"

 

# Detect paths

MYSQL=$(which mysql)

 

if [ $# -ne 4 ]

then

        echo "Usage: $0 {MySQL-User-Name} {MySQL-User-Password} {MySQL-Database-Name} {New-Base-URL}"

        echo "Changes the Base URL in a Magento install to {New-Base-URL}"

        exit 1

fi

 

for $DOMAIN

 

do

        echo "Changing Base URLs to $DOMAIN..."

        $MYSQL -u $MUSER -p$MPASS $MDB -e "update core_config_data set value = '$DOMAIN' where path = 'web/unsecure/base_url';"

        $MYSQL -u $MUSER -p$MPASS $MDB -e "update core_config_data set value = '$DOMAIN' where path = 'web/secure/base_url';"

done