=====""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)