<?php

$mysqluser = "root";
$mysqlpass = "enjay@crm123";

$unwanteddbarray = array("information_schema","mysql","phpmyadmin","performance_schema");
$dbarray = array();
$link = mysql_connect("localhost","$mysqluser","$mysqlpass");
$res = mysql_query("SHOW DATABASES");
while ($row = mysql_fetch_assoc($res))
{
	$dbname = $row['Database'];
	if (!in_array($dbname,$unwanteddbarray))
	{
		array_push($dbarray,$dbname);
	}
}

$day = trim(`date +'%A'`);

if($day != "")
{
`rm -rf /disk2/backup/sqldata/$day/*`;
}

foreach($dbarray as $value)
{
	`mysqldump -u"$mysqluser" -p"$mysqlpass" $value > /disk2/backup/sqldata/$day/$value.sql`;
	`tar czf /disk2/backup/sqldata/$day/$value.tar.gz /disk2/backup/sqldata/$day/$value.sql 2>&1 > /dev/null`;
	`rm -rf /disk2/backup/sqldata/$day/$value.sql`;
}
?>