rakesh-mohanta · March 5, 2016 07:28 · Feb 8, 2013 · Jan 13, 2013 · Jan 13, 2013 · Jan 13, 2013
diff --git a/backup-cleanup → backup-cleanup.sh b/backup-cleanup → backup-cleanup.sh
diff --git a/backup-databases → backup-databases.sh b/backup-databases → backup-databases.sh
diff --git a/backup-wordpress-site-files → backup-wordpress-site-files.sh b/backup-wordpress-site-files → backup-wordpress-site-files.sh
diff --git a/logrotate.conf b/logrotate.conf
@@ -0,0 +1,35 @@
+# see "man logrotate" for details
+# rotate log files weekly
+daily
+
+# keep 2 weeks worth of backlogs
+rotate 1
+
+# create new (empty) log files after rotating old ones
+create
+
+# use the date in backlog filenames
+dateext
+
+# compress backlogs with a delay
+compress
+
+# packages drop log rotation information into this directory
+include /etc/logrotate.d
+
+# no packages own wtmp, or btmp -- we'll rotate them here
+/var/log/wtmp {
+    missingok
+    weekly
+    create 0664 root utmp
+    rotate 7
+}
+
+/var/log/btmp {
+    missingok
+    weekly
+    create 0664 root utmp
+    rotate 7
+}
+
+# system-specific logs may be configured here
diff --git a/server-reboot → server-reboot.sh b/server-reboot → server-reboot.sh
diff --git a/backup-databases b/backup-databases
@@ -13,7 +13,7 @@ DBPwd="[user password]";
 
 for DB in $DBList; 
 do
-21mysqldump --opt -u$DBUser -p$DBPwd --add-drop-table --lock-tables --databases $DB > $BackUpDIR$DateStamp.$DB.sql;
+mysqldump --opt -u$DBUser -p$DBPwd --add-drop-table --lock-tables --databases $DB > $BackUpDIR$DateStamp.$DB.sql;
 	tar zcf "$BackUpDIR$DateStamp.DB.$DB.tar.gz" -P $BackUpDIR$DateStamp.$DB.sql;
 	rm -rf $BackUpDIR$DateStamp.$DB.sql;
 	mysqldump --opt -u$DBUser -p$DBPwd --add-drop-table --lock-tables $DB > $BackUpDIR$DateStamp.$DB.tbls.sql;

diff --git a/backup-wordpress-site-files b/backup-wordpress-site-files
@@ -10,7 +10,7 @@ DateStamp=$(date +"%Y%m%d");
 
 for Site in $SiteList; 
 do
-21#backup all files, however, exclude the rackspace cloud cdn if you are using it
+#backup all files, however, exclude the rackspace cloud cdn if you are using it
  	tar zcf "$BackUpDIR$DateStamp.website.code.$Site.tar.gz" -P $SrvDir$Site --exclude "$SrvDir$Site/wp-content-cloudfiles";
 done
 #-----------------------------------------------------------------------

diff --git a/backup-cleanup b/backup-cleanup
@@ -0,0 +1,13 @@
+#!/bin/bash
+#start
+#-----------------------------------------------------------------------
+find /srv/backup/daily/databases/ -name '*.gz' -mtime +7 | xargs rm -f;
+find /srv/backup/daily/websites/ -name '*.gz' -mtime +7 | xargs rm -f;
+# Are Weekly Backups Implemented? 
+# find /srv/backup/weekly/ -name '*.gz' -mtime +30 | xargs rm -f;
+#-----------------------------------------------------------------------
+#end
+
+# Example Schedule
+# Remove Backups Greater than 7 Days Old Daily @ 01:00 AM
+# 00 01 * * * root /etc/cron.daily/backup-cleanup
diff --git a/gistfile1.txt → backup-wordpress-site-files b/gistfile1.txt → backup-wordpress-site-files
diff --git a/gistfile1.txt b/gistfile1.txt
@@ -0,0 +1,22 @@
+#!/bin/bash
+#start
+#-----------------------------------------------------------------------
+#verify directory structure exists prior to running this job
+BackUpDIR="/srv/backup/daily/websites/";
+SrvDir="/srv/www/";
+#Format of SiteList="sitefolder1 sitefolder2 sitefolder3"
+SiteList="[sitefolders]";
+DateStamp=$(date +"%Y%m%d");
+
+for Site in $SiteList; 
+do
+21#backup all files, however, exclude the rackspace cloud cdn if you are using it
+ 	tar zcf "$BackUpDIR$DateStamp.website.code.$Site.tar.gz" -P $SrvDir$Site --exclude "$SrvDir$Site/wp-content-cloudfiles";
+done
+#-----------------------------------------------------------------------
+#end
+
+# Example Schedule
+# Backup Wordpress Site Files Daily @ 12:45 AM
+# 45 00 * * *	root /etc/cron.daily/backup-wordpress-site-files
+
diff --git a/backup-databases b/backup-databases
@@ -0,0 +1,28 @@
+#!/bin/bash
+#start
+#-----------------------------------------------------------------------
+#verify directory structure exists prior to running this job
+BackUpDIR="/srv/backup/daily/databases/";
+DateStamp=$(date +"%Y%m%d");
+
+#Format of DBList="db1 db2 db3 db4"
+DBList="[dbname]";
+#I have a server system administrator account with access to all dbs, typically named sysadmin
+DBUser="[user with db permissions like sysadmin]";
+DBPwd="[user password]";
+
+for DB in $DBList; 
+do
+21mysqldump --opt -u$DBUser -p$DBPwd --add-drop-table --lock-tables --databases $DB > $BackUpDIR$DateStamp.$DB.sql;
+	tar zcf "$BackUpDIR$DateStamp.DB.$DB.tar.gz" -P $BackUpDIR$DateStamp.$DB.sql;
+	rm -rf $BackUpDIR$DateStamp.$DB.sql;
+	mysqldump --opt -u$DBUser -p$DBPwd --add-drop-table --lock-tables $DB > $BackUpDIR$DateStamp.$DB.tbls.sql;
+	tar zcf "$BackUpDIR$DateStamp.DB.$DB.tbls.tar.gz" -P $BackUpDIR$DateStamp.$DB.tbls.sql;
+	rm -rf $BackUpDIR$DateStamp.$DB.tbls.sql;
+done
+#-----------------------------------------------------------------------
+#end
+
+# Example Schedule
+# Backup Databases Daily @ 12:30 AM
+# 30 00 * * *	root /etc/cron.daily/backup-databases
diff --git a/server-reboot b/server-reboot
@@ -0,0 +1,17 @@
+#!/bin/bash
+#start
+#-----------------------------------------------------------------------
+
+#delete nginx cache if exists
+rm -rf /var/cache/nginx
+#restart server
+DateStamp=$(date +"%Y%m%d %k:%M:%S");
+echo $DateStamp >> /var/log/cron.reboot.log;
+/sbin/shutdown -r now
+
+#-----------------------------------------------------------------------
+#end
+
+# Example Schedule
+# Reboot Server Daily @ 1:30 AM
+# 30 01 * * *  root /etc/cron.daily/server-reboot
No results found