Easy Drupal maintenance and upgrades

Hi,

great script. I have used some of your ideas (DB array, download Drupal 5.x) in my script. I also have a script to update Drupal, and another one to update modules. My script also backs up the entire website into a tar.gz file. It also makes a copy of the .htaccess, robots.txt and settings.php files.

Have you figured out a method of running update.php from a script?

You can see further info here: http://drupal.org/node/299039 and here: http://drupal.org/node/299199

Thanks.

Cheers,

Paul

Updated to 5.7 successfully with the below code:

#!/bin/bash
# update_drupal.sh

USAGE="Usage: $0 <version>"

VERSION=${1?$USAGE}
DOWNLOAD_URL=http://ftp.drupal.org/files/projects/
DRUPAL=drupal-${VERSION}

DB=("<db1>" "<db2>")
DB_USER=<user>
DB_PASS=<pass>
DB_BAK_PATH=./bak/db/

DATE_TODAY=`date +%Y%m%d`

USER=<user>
GROUP=<group>
APACHE_USER=apache

function check_error() 
{
        if (( e = $? )); then
                echo "ERROR: $e, $1 Exiting..."
                exit $e
        else
                echo $2 
        fi
}


#// Make a backup of database
for ((i=0; i<${#DB[@]}; i++))
do
  echo "Creating backup of database ${DB[$i]} ..."
  mysqldump --opt -u $DB_USER --password=${DB_PASS} ${DB[$i]} > ${DB_BAK_PATH}${DB[$i]}_${DATE_TODAY}.sql
  check_error "${DB[$i]} failed to backup." "${DB[$i]} successfully backed up."
done

#// Download source
echo "Downloading source ${DOWNLOAD_URL}${DRUPAL}.tar.gz ..."
wget ${DOWNLOAD_URL}${DRUPAL}.tar.gz
check_error "Download source failed." "Download source done."

#// Extract source
echo "Extracting ./${DRUPAL}.tar.gz ..."
tar -xzf ./${DRUPAL}.tar.gz
check_error "Source extraction failed." "Source extraction done."

#// Port custom .htaccess content over
echo "Porting custom .htaccess content over ..."
BYTE_OFFSET=$(expr `grep -b "Apache/PHP/Drupal settings:" ./html/.htaccess | awk -F':' '{print $1}'` - 2)
head -c $BYTE_OFFSET ./html/.htaccess | cat - ./${DRUPAL}/.htaccess > ./${DRUPAL}/.htaccess.new && 
mv ./${DRUPAL}/.htaccess.new ./${DRUPAL}/.htaccess 
check_error ".htaccess porting failed." "Porting custom .htaccess complete."

#// Set the permissions
echo "Setting permissions for ${USER}:${GROUP} ..."
chown -R ${USER}:${GROUP} ./$DRUPAL &&
chown $APACHE_USER ./$DRUPAL/.htaccess &&
find ./$DRUPAL -type d -exec chmod 755 {} \; &&
find ./$DRUPAL -type f -exec chmod 644 {} \;
check_error "Setting permissions failed." "Setting permissions done."

#// Link the sites
echo "Linking the ./${DRUPAL}/sites folder ..."
mv ./${DRUPAL}/sites ./${DRUPAL}/sites_orig && ln -s ../drupal_sites ./${DRUPAL}/sites
check_error "Linking sites failed." "Linking sites done."

#// Link the site_files
echo "Linking ./${DRUPAL}/site_files ..."
ln -s ../site_files ./${DRUPAL}/site_files
check_error "Linking site_files failed." "Linking site_files done."

#// Update the html link
echo "Updating html link to $DRUPAL ..."
rm -f ./html && ln -s $DRUPAL html
check_error "Linking html failed." "Updating html link done."

#// Clean up the txt files
echo "Cleaning drupal txt files"
find ./html/ -name "*.txt"| grep -v robots.txt| xargs rm -f
check_error "Clean up of txt files failed." "Drupal txt files removed."

#// Clean Up of source
echo "Removing source file ..."
rm -f ./$DRUPAL.tar.gz
check_error "Could not remove source file." "Removing source file done."

#// Echo futher instructions
echo "Run the update.php script for each site."

exit 0