This script is called genQL, I started developping it at the start of 2010 to backup our websites and mysql databases. Written by JuPiTeR (Nelson-Jean Gaasch), thanks to the precious help of Nuxien (Johan Roussel) and grosboulet. Please be sure you don't email us telling this script is sh*t without mentioning why and how you would improve it better (precise code example wanted) :) thank you ^^ This script has the following dependencies: * usual binutils, rsync, wget, mailx. * apache2-utils sharutils (debian packages for htpasswd and uuencode) #### # dat file specifications: Each line represents a site to backup # dns;active;protocol;l0gin;ftpassword;sshkeyname;loginhtacces;passhtaccess;altdns;port;rpath;timesite;daysite;timedb;daydb;coef;GB;priority;pingtest # dns: Contains the dns of the site to save # active: 1 if site's backup is active ; 0 if it's inactive # protocol: ftp or ssh # login: Which login to use to login to the site # pass: Password for login (ONLY for FTP ; for ssh, RSA key-authentication is used) # sshkeyname; name of the ssh key to be used # loginhtaccess: login to be used for the site's htaccess # passhtaccess: pass to be used for the site's htaccess # altdns: Sometimes, the ftp to backup a site doesn't have the same address as the site itself, this is where you declare it # port: does the ftp/ssh service run on a particular port? # rpath: Where on the server is the directory? (important for the .htaccess) # timesite: Time where the site should be backed-up # daysite: Day the site should be backed up # timedb: time of the db backup # daydb: Day the DB should be backed up # coef: coeficient of space # GB: Allowed backup size # Priority: Allows to define which sites are the most important ones to backup # Pingtest: should we perform a pingtest with this site? #####