This little scripts create's a backup of your database and website files at once and puts them on a folder on your webhosting.

PLAIN TEXT
PHP:
  1. function backupDB($dbhost,$dbuser,$dbpass,$dbname, $sitename){
  2. global $savepath , $date ;
  3.  
  4. $date = date("dmY");
  5. if (!file_exists("$savepath/$date")) {
  6. mkdir("$savepath/$date", 0777);
  7. }
  8. $filename = "$savepath/$date/SQL$sitename-$date.sql";
  9.  
  10. passthru("mysqldump --opt -h$dbhost -u$dbuser -p$dbpass $dbname>$filename");
  11.  
  12. }

PLAIN TEXT
PHP:
  1. function backupWWW($wwwdirectory,$wwwname){
  2. global $savepath , $date ;
  3. if (!file_exists("$savepath/$date")) {
  4. mkdir("$savepath/$date", 0777);
  5. }
  6. $filename = "$savepath/$date/WWW$wwwname.tar.gz";
  7.  
  8. $zipline = "tar -czf $filename $wwwdirectory";
  9. shell_exec($zipline);
  10.  
  11. }

PLAIN TEXT
PHP:
  1. $settings = array( array( dbhost => 'myserver1.domain.net',
  2. dbuser => 'username',
  3. dbpass => 'pasword',
  4. dbname => 'dbname',
  5. wwwname => 'webfoldername',
  6. wwwdirectory => '/mounted-storage/pathtowebfolder/*'
  7. ),
  8. array( dbhost => 'myserver.domain.net',
  9. dbuser => 'username',
  10. dbpass => 'pasword',
  11. dbname => 'dbname',
  12. wwwname => 'webfoldername',
  13. wwwdirectory => '/mounted-storage/pathtowebfolder/*'
  14. )
  15.  
  16. );

PLAIN TEXT
PHP:
  1. for ( $row = 0; $row <count($settings); $row++ )
  2. {
  3. backupDB($settings[$row]['dbhost'], $settings[$row]['dbuser'], $settings[$row]['dbpass'], $settings[$row]['dbname'], $settings[$row]['wwwname']);
  4. backupWWW($settings[$row]['wwwdirectory'],  $settings[$row]['wwwname']);
  5. echo $settings[$row]['wwwname'] ."backup up
  6. ";
  7. }

del.icio.us:Creating a MySQL db and website backup at once digg:Creating a MySQL db and website backup at once spurl:Creating a MySQL db and website backup at once furl:Creating a MySQL db and website backup at once reddit:Creating a MySQL db and website backup at once fark:Creating a MySQL db and website backup at once Y!:Creating a MySQL db and website backup at once

Related Posts