backupDoGo.php

<?php
#script a mettre sur le serveur de secours
#require backupDoDataOnly.php
#settings MySQL
$serveur= $_SERVER["HTTP_HOST"]; // identifie serveur
if ($serveur=="www.-.ch"){ //serveur de backups
      $dbUsername = "";
      $dbPassword = "";
      $dbHostname = "";
      $dbName     = "";      

}


  $host = $dbHostname;
  $user = $dbUsername;
  $pass = $dbPassword;

  $base = $dbName;
  #echo "mysql_connect($host, $user, $pass,$base)";
  mysql_connect($host, $user, $pass);
  mysql_select_db($base);

#echo $content;
if ($serveur!=""){//on sort si pas serveur de secours
exit;
}
 //serveur de backups

	$viderSql="
	TRUNCATE `animateurs`
	";
	$viderSqlQ=mysql_query($viderSql);
		if(!$viderSqlQ) {
		echo "Problème avec la suppression des données du " .date("d-m-Y h:i") .", erreur MySQL: " .mysql_error();
		}
	
	$viderSql="
#...

#open file from main server
	if($fd = fopen ("http://.../backups/backupDoDataOnly.php", "r")) { ;
echo "Doing backup please wait...";

	
		while (!feof ($fd)) {
		$buffer = fgets($fd, 4096);
		#echo $buffer;
		$backup=mysql_query($buffer);
					if(!$backup) {
			echo "Problème avec le backup du " .date("d-m-Y h:i") .", erreur MySQL: " .mysql_error() ."<br>";
			}
		}
	fclose ($fd);
		} else {
	echo "Problem reading file http://.../backups/backupDoDataOnly.php";
	exit;
	}
?>