Backup Linux server with PHP

Copy Source http://www.redips.net/php/backup-linux-server/
Tweet

You can find a lot of backup solutions for Linux server. From expensive and multi platform software like NetBackup to simple BASH scripts. As a Linux (LAMP) administrator, I decided to write my own backup script in PHP. I wanted to backup important locations like Web root, crontabs, /etc, /root and copy MySQL dump files. My script should be able to copy created tar.gz files and MySQL dumps to the remote server.

In post LAMP setup: Beginning I suggest how to arrange partitions for the LAMP server. Last mentioned partition was /backup and this is the location to save daily backups for the LAMP server – it’s big enough to keep backup for the last three days. I will not explain backup strategy, but in my case, I am satisfied with archived files to the local directory (partition) and remote server.

At the end, you will see complete PHP Backup class. Now I will show example how to save content of the /etc directory to the local directory.

// initialize Backup class and define local directory
$backup = new Backup(‘/backup/archive’);
// make backup of the /etc directory
$backup->tar(‘/etc’);

After backup is done, you will see log file in the /tmp directory and etc_2009-03-26.tar.gz in the /backup/archive directory. You can name the backup file if you like. For example, you can include /var/spool/cron files to the backup, and name it crontabs:

// initialize Backup class and define local directory
$backup = new Backup(‘/backup/archive’);
// backup crontab files
$backup->tar(‘/var/spool/cron’, ‘crontabs’);

Like in the previous example, crontabs_2009-03-25.tar.gz will be saved to the /backup/archive directory. One of my LAMP servers mounts exported NFS directory to the document root. I have to backup document root, but without mounted directory. So if you have similar situation, you can exclude files from the archive based upon pattern search.

// initialize Backup class and define local directory
$backup = new Backup(‘/backup/archive’);
// backup document root, but without mnt directory
$backup->tar(‘/var/www’, ‘www’, ‘html/mnt/*’);

Third parameter of the method “tar” means “exclude”, so if you need to use exclude parameter, you will have to define and the second parameter – name. All this examples save created archive to the local directory. With “tarc” and “rcopy” methods, archives can be copied to the remote server by scp command. Before you start to use “tarc” and “rcopy” method, you will have to exchange keys between LAMP server and remote server. Here is example how to backup Web server to the local directory and to the remote server:

// initialize Backup class, define local directory and remote server
$backup = new Backup(‘/backup/archive’, ‘user@server1:/backup/lamp1’);
// backup document root, etc and crontab directory
$backup->tarc(‘/var/www’);
$backup->tarc(‘/etc’);
$backup->tarc(‘/var/spool/cron’, ‘crontabs’);

Backup class has option to recursive copy matched files to the remote location. You will have to define start point and the pattern to match files. I have to copy MySQL daily backups to the remote server. Another script – automysqlbackup.sh exports MySQL databases to the file system. Dump files have current date and “sql” in the name, so backup script will copy “sql” files with current date in the name to the user@server1:/backup/lamp1 remote location.

// initialize Backup class, define local directory and remote server
$backup = new Backup(‘/backup/archive’, ‘user@server1:/backup/lamp1’);
// define current date (needed to find recent MySQL dump files)
$today = date(‘Y-m-d’);
// backup document root, etc, root home and crontab files
$backup->tarc(‘/var/www’);
$backup->tarc(‘/etc’);
$backup->tarc(‘/root’, ‘root_home’);
$backup->tarc(‘/var/spool/cron’, ‘crontabs’);
// copy MySQL dump files to the remote server
$backup->rcopy(‘/usr/mysql/export/daily’, “*$today*sql*”);

As you can see, Backup class has many options, but it’s not perfect. It can be extended with ftp option, without need for the local directory, option to define path and name of the log file … I tried to write readable and well commented PHP code, so you shouldn’t have any problem to understand, modify or customize Backup class for your needs.

/**
* Backup class has three public methods
* tar – saves archive to the local directory
* tarc – saves archive to the local directory and copies to the remote destination
* rcopy – recursive copy matched files to the remote location
*
*/
class Backup{
// define private properties
private $log; // pointer to the log object
private $backup_dir; // local directory
private $scp_server; // remote destination

/**
* constructor
*
* @param string $backup_dir – local directory where tar.gz files should be saved
* @param string $scp_server – (optional) remote location to save archives
*/
function __construct($backup_dir, $scp_server=null){
$this->log = new Logging(); // initialize Logging class
$this->backup_dir = $backup_dir; // set local backup directory
$this->scp_server = $scp_server; // set remote location
}

/**
* method saves archive to the local directory and copies to the remote destination
*
* @param string $dir – directory you want to archive
* @param string $name – (optional) name of the created archive
* @param string $exclude – (optional) excluded files from archive based upon pattern
*/
public function tarc($dir, $name=null, $exclude=null){
// call tar method to create archive in the local directory
$tar = $this->tar($dir, $name, $exclude);
// after archive is created, copy archive to the remote location
$this->scp($tar);
}

/**
* method saves archive to the local directory
*
* @param string $dir – directory you want to archive
* @param string $name – (optional) name of the created archive
* @param string $exclude – (optional) files / subtree to exclude from tar
*/
public function tar($dir, $name=null, $exclude=null){
// get local backup directory from the class property
$backup_dir = $this->backup_dir;
// define current date
$today = date(‘Y-m-d’);
// if tar name is not defined, use base name of the given path
if (!$name) $name = basename($dir);
// create complete tar name (path and name)
$tar = “$backup_dir/$name”.”_$today.tar.gz”;
// define excluded files based upon pattern (if needed)
if ($exclude) $exclude = “–exclude=\”$exclude\””;
// remove leading ‘/’ from the path
$dir = substr($dir, 1);
// execute tar command relative from / directory to
// avoid “tar: Removing leading `/’ from member names” warning
$this->run(“tar zcf $tar $exclude -C / $dir”);
// return tar name (needed for tarc method)
return $tar;
}

/**
* recursive copy matched files to the remote location
*
* @param string $dir – directory to start with
* @param string $pattern – pattern to search
*/
public function rcopy($dir, $pattern){
// find files matching pattern
$files = $this->find($dir, $pattern);
// loop through found files and call scp method
foreach ($files as $file) $this->scp($file);
}

/**
* create scp command and call run method
*
* @param string $file – absolute path to the source file
*/
private function scp($file){
// get remote location from the class property
$scp_server = $this->scp_server;
// execute and log scp command if scp server is defined
if ($scp_server) $this->run(“/usr/bin/scp -pq $file $scp_server/”);
else $this->log->lwrite(“Warning: scp server is not defined for $file!”);
}

/**
* method executes given command and logs to the log file
*
* @param string $command – command to execute
*/
private function run($command){
// execute command and redirect STDERR to the STDOUT
$output = shell_exec(“$command 2>&1”);
// log command and command output if exists to the log file
$this->log->lwrite($command);
if ($output) $this->log->lwrite($output);
}

/**
* find files matching a pattern
* using unix “find” command
*
* @return array containing all pattern-matched files or empty array
*
* @param string $dir – directory to start with
* @param string $pattern – pattern to search
*/
private function find($dir, $pattern){
// escape any character in a string that might be used to trick
// a shell command into executing arbitrary commands
$dir = escapeshellcmd($dir);
// if directory exists, then execute find command
if (file_exists($dir)){
// execute “find” and return string with found files
$files = shell_exec(“find $dir -name ‘$pattern’ -print”);
// create array from the returned string (trim will strip the last newline)
$files = explode(“\n”, trim($files));
// return array
return $files;
}
// else write warning to the log and return empty array
else{
$this->log->lwrite(“Warning: $dir does not exist (find)!”);
return Array();
}
}
}

You have probably noticed initialization of the Logging class in the constructor, but you can’t find the code. Logging class is described in Write to a log file with PHP, so you only need to place Logging and Backup class to the same PHP file. I also used code from my previous post Find files with PHP for private method “find”. The only modification is in checking if directory exists.

Read more

世界越快心越慢

在晚飯後的休息時間,我特別享受在客廳瀏灠youtube上各樣各式創作者的影音作品。很大不同於傳統媒體,節目多是針對大多數族群喜好挑選的,在youtube上我會依心情看無腦的動畫、一些旅拍記錄、新聞時事談論。 尤其在看了大量的Youtube的分享後,我真的感受到會限制我的是我的無知,特別是那些我想都沒想過的實際應用,在學習後大大幫助到我的生活和工作層面。 休息在家時,我喜歡想一些沒做過的菜,動手去設計生活和工作上的解決方案,自己是真的很難閒著沒事做。 如創作文章,陪養新的習慣都能感覺到成長的喜悅,是不同於吃喝玩樂的快樂的。 創作不去限制固定的形式,文字是創作、影像聲音也是創作,記錄生活也是創作,我想留下的就是創造—》實現—》回憶,這樣子的循環過程,在留下的足跡面看到自己一路上的成長、失敗、絕望、重新再來。 雖然大部份的時候去做這些創作也不明白有什麼特別的意義,但不去做也不會留下什麼,所以呀不如反事都去試試看,也許能有不一樣的水花也許有意想不到的結果,投資自己永遠不會是失敗的決定,不是嗎?先問問自己再開始計畫下一步,未來沒人說得準。 像最近看youtube仍大一群人在為DOS開

By Phillips Hsieh

知識管理的三個步驟:一小時學會把知識運用到生活上

摘錄瓦基「閱讀前哨站」文章作為自己學習知識管理的內容 Part1「篩選資訊」 如何從海量資訊中篩選出啟發性、實用性和相關性的精華,讓你在學習過程中不再迷失方向。 1. 實用性 2. 啟發性 Part2「提高理解」 如何通過譬喻法和應用法,將抽象的知識與日常生活和工作緊密結合,建立更深刻的理解。 1. 應用法 2. 譬喻法 Part3「運用知識」 如何連結既有知識,跟自己感興趣的領域和專案產生關聯,讓你在運用知識的路途上游刃有餘。 1. 跟日常工作專案、人際活動產生連結 # 為什麼要寫日記? * 寫日記是為了忘記,忘卻瑣碎事情,保持專注力 * 寫日記就像在翻譯這個世界,訓練自己的解讀能力 * 不只是透過日記來記錄生活,而是透過日記來發展生活 #如何寫日記? * 不要寫流水帳式的日記,而是寫覆盤式的日記 當我們試著記錄活動和感受之間的關聯,有助於辦認出真正快樂的事 日記的記錄方式要以過程為主,而非結果 * 感恩日記的科學建議,每日感恩的案例

By Phillips Hsieh
2024年 3月30日 14屆美利達環彰化百K

2024年 3月30日 14屆美利達環彰化百K

這是場半小時就被秒報名額滿的經典賽事, 能順利出賽實屬隊友的功勞, 這次的準備工作想試試新買的外胎, 因為是無內胎用的外胎, 特別緊超級難安裝的, 問了其他朋友才知道, 要沾上肥皂水才容易滑入車框。 一早四點起床準備, 五點集合備好咖啡在車上飲用, 約了六點在彰化田尾鄉南鎮國小, 整好裝四人一起出發前往會場。 被排在最後一批出發, 這次的路線會繞行的員林148上139縣道, 其實在早上五點多天就開始有點飄雨, 大伙就開始擔心不會要雨戰吧! 果不其然才出發準備上148爬坡雨勢越來越大, 戴著防風眼鏡的我在身體的熱氣加上雨水冷凝效果下, 鏡面上滿是霧氣肉眼可視距離才剩不到五公尺, 只能緊依前前方的車友幫忙開路, 之後洪大跟上來我立馬請求他幫忙開路, 上了139停下車把防風眼鏡收起來, 反正下雨天又陰天完全用不到太陽眼鏡了。 雨是邊下邊打雷, 大伙都在這條139上一台一台單車好像避電針, 一時有點害怕不然想平時沒做什麼壞事, 真打到自己就是天意了。 下了139雨勢開始變小, 大伙的速度開始有所提昇, 開高鐵列車的時機己成熟, 物色好列車就跟好跟滿。 最後找了一隊似乎整團有固定在練

By Phillips Hsieh
2023 12月9號 美利達單車嘉年華

2023 12月9號 美利達單車嘉年華

第二次參加美利達環南投賽事, 還記得去年第一次參加這美利達環南投, 還特地提前一天跟車友在魚池住了一晚。 這回用上了剛在7月份剛安裝的車頂架, 安裝了二種不同的攜車架, 都樂這邊可以不用拆車輪直上車頂, YAKIMA這邊選了經濟的款式, 折掉前輪利用前叉固定在攜車架上。 約了唯一一位一起參加的朋友, 二人一早四點約見面, 幫朋友帶上了拿鐵咖啡, 開上日月潭在水社碼頭停好車, 騎往向山遊客中心, 路過美麗的日月潭簡直不要太美了拍一張。 抵達會場己是人山人海了, 跟著大伙排隊順便也看網紅也欣賞名車。 出發就先沿著日月潭順時針騎, 騎到玄裝寺很急停下來上一下廁所, 比賽時都會尿都特別的滿, 一方面是比較緊張,一方面是特別興奮。 這時己經跟車友失散了, 只能獨推沿路看有沒有車友可以一起組隊的, 很可惜在山區大家的實力不一只求平安順騎了, 原則就是有補給就停有食物就吃。 下到水里人群再次聚集起來, 光等紅綠燈就是一條車龍。 騎行了一大圈水里再回到131縣道, 這時背後傳來熟悉的聲音叫菲哥, 終於跟車友重新集合接下來就一路邊聊邊騎。 最後來幾張專業攝影師拍攝的照片 回到終點台上

By Phillips Hsieh