Group items tagged

#!/bin/bash # Nightly backup system for home directories and MySQL # databases for websites managed by CPanel. # Author: Kieran O'Shea # Author's Website: www.kieranoshea.com # Support: kieran@kieranoshea.com # License: GPLv2 # USAGE: Place this file inside the directory you want to # put backups in, set it as a CRON job to run and collect # backups from the site(s) you define below at a preset # time each day, or run it manually everytime you want to # take a backup. You can place an unlimited number of sites # and databases to be backed up in the variables below so # long as you follow the convention. It doesn't even matter # if your different domains are hosted in different locations # so long as they are all managed by CPanel. # Prerequisites: # - Linux box with bash shell # - wget installed # Define all the sites you wish to backup in the array below # Domain name and tld only, eg. kieranoshea.com domain=( domain1.com domain2.com ) # Define all the usernames for the above sites in the array # below - keep order consistant! user=( user1 user2 ) # Define all the passwords for the above usernames in the # array below - keep order consistant! If you log on as # reseller or root you can enter the same password in # every array position, but none the less they must be filled. pass=( pass1 pass2 ) # Number of databases in each domain above - keep order # consistant. If you don't wish to backup any databases # for a particular domain, or don't have any for it, place # a 0 in it's position in the array. no_of_db=( 3 1 ) # Database names, exactly as they are in CPanel, in the order # that the domains appear. You may like to log into CPanel # manually and check your database names before filling this # variable in. Number of db names here must match the above # variables also! Eg. all dbs in domain 1 followed by all # dbs in domain 2 etc. You DO NOT need to enter any database # names below for a domain if you have placed a zero for it # in the array above databases=( domain1_datebase1 domain1_datebase2 domain1_datebase3 domain2_datebase1 ) # Thats all folks, save the file, CHMOD it to be executable # by the user who will run it, and you are all set. # Do not edit anything below this point! echo echo "-----------------------------------------------------------------" echo "Kieran's nightly backup system started" echo "-----------------------------------------------------------------" echo "" echo "-----------------------------------------------------------------" echo "Creating a directory in your backup path for tonights backup..." echo "-----------------------------------------------------------------" FOLDER="$(date +%d-%m-%Y)" mkdir $FOLDER cd $FOLDER echo "-------" echo "Done!" echo "-------" echo "" echo "-----------------------------------------------------------------" echo "Creating a directory for every domain to be backed up into..." echo "-----------------------------------------------------------------" count=${#domain } i=0 while [ "$i" -lt "$count" ] do mkdir ${domain[$i]} let "i = $i + 1" done echo "-------" echo "Done!" echo "-------" echo "" echo "-----------------------------------------------------------------" echo "Backing up MySQL databases..." echo "-----------------------------------------------------------------" overall_db_count=0 count=${#domain } i=0 while [ "$i" -lt "$count" ] do cd ${domain[$i]} mkdir databases cd databases start_point=$overall_db_count # start point for iterating over the array of db names let "end_point = $overall_db_count + ${no_of_db[$i]}" # end point to stop iterating (always the overall count!) n=$start_point while [ "$n" -lt "$end_point" ] do wget http://${user[$i]}:${pass[$i]}@www.${domain[$i]}:2082/getsqlbackup/${databases[$n]}.gz let "n = $n + 1" done let "overall_db_count = $overall_db_count + ${no_of_db[$i]}" # increase the overall count to keep a tally cd .. cd .. let "i = $i + 1" done echo "-------" echo "Done!" echo "-------" echo "" echo "-----------------------------------------------------------------" echo "Backing up home directories; this make take some time..." echo "-----------------------------------------------------------------" count=${#domain } i=0 while [ "$i" -lt "$count" ] do cd ${domain[$i]} wget http://${user[$i]}:${pass[$i]}@www.${domain[$i]}:2082/getbackup/backup-${domain[$i]}-$FOLDER.tar.gz cd .. let "i = $i + 1" done echo "-------" echo "Done!" echo "-------" echo "" echo "-----------------------------------------------------------------" echo "All backup tasks completed. Goodnight!" echo "-----------------------------------------------------------------"

#!/usr/bin/perl -w use MIME::Lite; $msg = MIME::Lite->new( From => mysqlbackup@your-email.com, To => you@your_distination-mail.com, Subject => backupdb.tgz MySQL backup!, Type => text/plain, Data => "Here are the MySQL database backups."); $msg->attach(Type=>application/x-tar, Path =>"/backupdb/backupdb.tgz", Filename =>"backupdb.tgz"); $msg->send; now run this job every night at 00:00 add job to crontab -e 0 0 * * * /myscripts/mysqlbackup

Update 2010-11: Configure PHP for User Directories. There have been more than a couple searches leading here that are similar to "configure PHP virtual hosts". There was a change to the default Apache config introduced in Ubuntu 10.4, Lucid Lynx. There is a message in the /etc/apache2/mods-available/php5.conf file that tells you what to do. REMEMBER: Restart apache and clear your browser's cache after the changes are made. A more detailed description is given at the Ubuntu User-Directory-PHP Wiki. Here is my copy with the (totally unprofessional) hack to get my ".file" files processed as PHP. <IfModule mod_php5.c>   AddHandler application/x-httpd-php .php .html .htm .file   <FilesMatch "\.ph(p3?|tml)$">     SetHandler application/x-httpd-php   </FilesMatch>   <FilesMatch "\.phps$">     SetHandler application/x-httpd-php-source   </FilesMatch>   # To re-enable php in user directories comment the following lines   # (from <IfModule ...> to </IfModule>.) Do NOT set it to On as it   # prevents .htaccess files from disabling it.     #<IfModule mod_userdir.c>     # <Directory /home/*/public_html>     # php_admin_value engine Off     # </Directory>     #</IfModule> </IfModule>

Apache2: Virtual Hosts for Clients in Your Private LAN & PHP Configuration Go to the first page Apache2 public_html & Virtual Directories and read the disclaimer. Thanks. Update 2010-11: Configure PHP for User Directories. There have been more than a couple searches leading here that are similar to "configure PHP virtual hosts". There was a change to the default Apache config introduced in Ubuntu 10.4, Lucid Lynx. There is a message in the /etc/apache2/mods-available/php5.conf file that tells you what to do. REMEMBER: Restart apache and clear your browser's cache after the changes are made. A more detailed description is given at the Ubuntu User-Directory-PHP Wiki. Here is my copy with the (totally unprofessional) hack to get my ".file" files processed as PHP. <IfModule mod_php5.c>   AddHandler application/x-httpd-php .php .html .htm .file   <FilesMatch "\.ph(p3?|tml)$">     SetHandler application/x-httpd-php   </FilesMatch>   <FilesMatch "\.phps$">     SetHandler application/x-httpd-php-source   </FilesMatch>   # To re-enable php in user directories comment the following lines   # (from <IfModule ...> to </IfModule>.) Do NOT set it to On as it   # prevents .htaccess files from disabling it.     #<IfModule mod_userdir.c>     # <Directory /home/*/public_html>     # php_admin_value engine Off     # </Directory>     #</IfModule> </IfModule>