Like many people at fridu.org we use a LAMP web server. To be more accurate fridu.org is developped on joomla! framework which uses PHP, MySQL and Apache.
Our problem was to find a simple way to backup all the Apache web data and the Mysql DB every night and to transfer the resulting backup files to an other server.
Obviously it had to be entirely automatic and to report error or success by email.
The small tool that we have developped, consists in a simple crontab enabled bash script which run on the web server. It archives the Apache and the MySQL data in a compressed tar file which is later transfered via scp to a second remote server.
The backup script provides for rotation of the archive files.
A second script runs on the remote server to rotate the received archive files.
You will find a detailled description and the scripts sources in our wiki.
In the future we will likely replace that solution with the bacula system that we already use for an other part of our server. Bacula provide a far more sofisticated concept but requires more work to configure and a full access to install the software if your server distribution doesn't provide it by default.
If you don't know bacula, have a look at it, it's simpler to use than it looks and it's great.
| < Prev |
|---|
