<?		

//	require("../config/config.php");				
	
	define("ROOT_DB","/home/metrosys/db/current");						

	define("DB_PREFIX",'metro');		

	define("DB_HOST",'localhost');		
	define("DB_NAME","metro_console");		
	define("DB_USER","metro_admin");		
	define("DB_PASSWORD","admin123#@!");
	
	$date = date("Y-m-d-H-i-s");	
	$directory = ROOT_DB."/backup_".$date."/";		

	$conn = mysql_connect(DB_HOST,DB_USER,DB_PASSWORD) or die("no connection");					
	
	mkdir($directory, 0777, true);	
		
	$db_list = mysql_list_dbs($conn);
			
	while ($results = mysql_fetch_object($db_list))
	{
		$dbname = $results->Database;
									
		$split = explode("_",$dbname);
					
		if($split[0] == DB_PREFIX)
		{
			$backupFile = $dbname.'.sql.gz';

			$command = "mysqldump -u ".DB_USER." -p".DB_PASSWORD." ".$dbname." | gzip > $directory$backupFile";
			system($command);								
		}
	}	
		
?>