##Log on as "root" on your SME Server 

root#>mysql
mysql> update webcal set cal_name = replace(cal_name,'Old_Calendar_Name','New_Calendar_Name');

EX: The Athletic Director's Calender(AthDirector) needs to be changed to "Sports"
mysql> update webcal set cal_name = replace(cal_name,'AthDirector','Sports');

##Then

[root@hostname root]#mv /opt/Webcal/files/Old_Calendar_Name /opt/Webcal/files/New_Calendar_Name

EX: The Athletic Director's Calender(AthDirector) needs to be changed to "Sports"
[root@hostname root]#mv /opt/Webcal/files/AthDirector /opt/Webcal/files/Sports

[root@hostname root]#cd /opt/Webcal/files/Calender_Name

##Change from public calender to private calender
[root@hostname Calendar_Name]#mv .public .private

##Change from private calender to public calender
[root@hostname Calendar_Name]#mv .private .public
 

#!/bin/bash
##TAR_FILE is where the SQL dump and webcal folder will be saved
##CurrTAR_FILE is a copy of the above that can be transferred to another server periodically
##DATA_FILE is where the SQL dump is saved
##STAT_FILE is where disk info and a listing of the saved files to keep track of disk space etc,.

TAR_FILE=/home/e-smith/files/ibays/webcalbackup/html/Webcal-`date +%H%M%S`-`date -I`.tar
CurrTAR_FILE=/home/e-smith/files/ibays/webcalbackup/html/currentwebcal.tar
DATA_FILE=/home/e-smith/files/ibays/webcalbackup/html/webcaldata.`date +%H%M%S`-`date -I`.sql
STAT_FILE=/root/webcalstat.txt

mysqldump --add-drop-table webcal > $DATA_FILE;
tar -cvf $TAR_FILE /opt/WebCal/ $DATA_FILE
cp $TAR_FILE $CurrTAR_FILE
ls /home/e-smith/files/ibays/webcalbackup/html/*.tar > $STAT_FILE
df >> $STAT_FILE
cat $STAT_FILE |mail -s WebcalBackUpStats admin@XXX.company.com