=====""LampBack""=====
""LampBack"" is a PHP class I've developed to create simple automated backup scripts for LAMP-based websites. It makes a system call to [[http://dev.mysql.com/doc/en/mysqldump.html mysqldump]] to back up mysql databases to a file which can then be sent to a designated email address. By configuring a crontab to run ""LampBack"", you can create simple regular backup of your remotely hosted mysql databases.

""LampBack"" is hosted at the [[http://code.google.com/p/lampback/ google code site]]

===Directory===
[[http://lampback.googlecode.com/svn/trunk/ google code repository]]
[[http://lampback.googlecode.com/svn/trunk/test/ test scripts]]

===Usage===
%%(php)
// create object
$LampBack = new LampBack($debug=1);

// settings
$LampBack->mysqldump_path = '/usr/local/bin/mysqldump'; // default setting
$LampBack->db_user = 'USER';
$LampBack->db_pass = 'PASS';
$LampBack->mail_to = 'user@example.com';
$LampBack->mail_from = 'lampback-mailer';
$LampBack->tar_on = 1;
$LampBack->mail_on = 1;
$LampBack->save_files = 0;

// database (add as many as you want)
$LampBack->DATABASE['DB_NAME'] = '*';

// back up
if ( $num_dbs_backed = $LampBack->export() )
$LampBack->print_d("LampBack complete -- $num_dbs_backed databases backed up", 'green');
else
$LampBack->print_d('LampBack export failed');
%%

===Similar Projects===
[[http://blog.tvlgiao.com/2006/05/09/php-cron-job-backups.html PHP Script Backups Databases and Files]] (tvlgiao.com)