function backup_mysql($ID, $instance_id = 0)
{
include_once dirname(__FILE__) . '/ressources/class.mysql-multi.inc';
$sock = new sockets();
$unix = new unix();
$date_start = time();
$TpmPrefix = null;
$RemotePathSuffix = null;
$instancename = null;
$mysqlhotcopy = $unix->find_program("mysqlhotcopy");
$email_spacer = "==========================================";
if ($instance_id > 0) {
$mysql = new mysql_multi($instance_id);
$instancename = " ({$mysql->MyServer}) ";
}
if ($mysqlhotcopy == null) {
backup_events($ID, "mysql", "ERROR, unable to stat mysqlhotcopy");
if (is_file($unix->find_program("mysqldump"))) {
backup_events($ID, "mysql", "INFO,{$instancename} switch to mysqldump processing");
return backup_mysql_oldway($ID, $instance_id);
}
events("ERROR, unable to stat mysqlhotcopy", __FUNCTION__, __LINE__);
send_email_events("Backup Task {$ID}:: Unable to backup mysql datas ", "ERROR, unable to stat mysqlhotcopy", "backup");
return false;
}
$array = backup_mysql_databases_list($ID, $instance_id);
if (!is_array($array)) {
events("ERROR,{$instancename} unable to get databases list", __FUNCTION__, __LINE__);
send_email_events("Backup Task {$ID}::{$instancename} Unable to backup mysql datas ", "ERROR, unable to get databases list", "backup");
backup_events($ID, "mysql", "ERROR,{$instancename} unable to get databases list", __LINE__);
return false;
}
$q = new mysql();
if ($instance_id > 0) {
$q = new mysql_multi($instance_id);
$TpmPrefix = $instance_id;
$Socket = " --socket={$q->SocketPath}";
$RemotePathSuffix = "-{$q->MyServerCMDLINE}";
}
if ($q->mysql_password != null) {
$password = "******";
}
if ($q->mysql_admin != null) {
$user = "******";
}
$temporarySourceDir = $sock->GET_INFO("ExecBackupTemporaryPath");
if ($temporarySourceDir == null) {
$temporarySourceDir = "/home/mysqlhotcopy";
}
$temporarySourceDir = "{$temporarySourceDir}/mysql{$TpmPrefix}";
events("temporarySourceDir has ExecBackupTemporaryPath token was \"{$temporarySourceDir}\"", __FUNCTION__, __LINE__);
events("Creating {$temporarySourceDir}", __FUNCTION__, __LINE__);
@mkdir($temporarySourceDir, 0755, true);
if (!is_dir($temporarySourceDir)) {
events("Creating Unable to backup mysql datas ", "ERROR,{$instancename} {$temporarySourceDir} permission denied or no such file or directory", __FUNCTION__, __LINE__);
send_email_events("Backup Task {$ID}::{$instancename} Unable to backup mysql datas ", "ERROR, {$temporarySourceDir} permission denied or no such file or directory", "backup");
backup_events($ID, "mysql", "ERROR,{$instancename} {$temporarySourceDir} permission denied or no such file or directory");
return;
}
$BlacklistDatabases["performance_schema"] = true;
$BlacklistDatabases["mysql"] = true;
$BlacklistDatabases["log"] = true;
backup_events($ID, "mysql", "INFO,{$instancename} using {$temporarySourceDir} for temp backup");
while (list($num, $line) = each($array)) {
if (trim($line) == null) {
continue;
}
$database_name = trim(basename($line));
$database_nameSTR = strtolower($database_name);
if (isset($BlacklistDatabases[$database_nameSTR])) {
events("{$instancename}skipping database \"{$database_name}\"", __FUNCTION__, __LINE__);
backup_events($ID, "mysql", "INFO,{$instancename} mysqlhotcopy skip {$database_nameSTR} database", __LINE__);
continue;
}
backup_events($ID, "mysql", "INFO,{$instancename} mysqlhotcopy database ({$database_name}) stored in {$line} -> {$temporarySourceDir}");
$mysqlhotcopy_command = "{$mysqlhotcopy} --addtodest{$Socket}{$user}{$password} {$database_name} {$temporarySourceDir} 2>&1";
events("\"{$mysqlhotcopy_command}\"", __FUNCTION__, __LINE__);
exec($mysqlhotcopy_command, $results);
while (list($num_line, $evenement) = each($results)) {
if (preg_match("#No space left on device#", $evenement)) {
events("ERROR, backup No space left on device ({$temporarySourceDir})", __FUNCTION__, __LINE__);
backup_events($ID, "mysql", "ERROR,{$instancename} backup No space left on device ({$temporarySourceDir})\n" . implode("\n", $results));
if (is_dir($temporarySourceDir)) {
shell_exec("/bin/rm -rf {$temporarySourceDir}/*");
}
return;
}
events("{$evenement}", __FUNCTION__, __LINE__);
if (preg_match("#failed:#", $evenement)) {
events("ERROR,{$instancename} database: \"{$database_name}\" ({$evenement})", __FUNCTION__, __LINE__);
backup_events($ID, "mysql", "ERROR,{$instancename} database: \"{$database_name}\" ({$evenement})");
$fulltext = @implode("\n", $results);
send_email_events("Backup Task {$ID}::{$instancename} database: \"{$database_name}\" failed to backup ", "{$email_spacer}\n{$mysqlhotcopy_command}{$email_spacer}\nERROR:{$email_spacer}\n{$evenement}\n{$email_spacer}\n{$fulltext}", "backup");
}
}
backup_events($ID, "mysql", "INFO,{$instancename} backup {$database_name}\n" . implode("\n", $results), __LINE__);
if (strtolower($database_name) == "zarafa") {
events("{$instancename}zarafa database -> backup_mysql_database_mysqldump({$ID},zarafa,{$temporarySourceDir})", __FUNCTION__, __LINE__);
backup_mysql_database_mysqldump($ID, "zarafa", $temporarySourceDir, $instance_id);
}
}
backup_events($ID, "mysql", "INFO,{$instancename} Send mysql backup to the \n" . implode("\n", $results));
events("Create directory \"{$GLOBALS["MOUNTED_PATH_FINAL"]}/mysql{$RemotePathSuffix}\"", __FUNCTION__, __LINE__);
backup_mkdir("{$GLOBALS["MOUNTED_PATH_FINAL"]}/mysql{$RemotePathSuffix}");
backup_copy("{$temporarySourceDir}/*", "mysql{$RemotePathSuffix}", $ID);
backup_events($ID, "mysql", "INFO,{$instancename} backup remove content of {$temporarySourceDir}/*");
events("INFO,{$instancename} backup remove content of {$temporarySourceDir}/*", __FUNCTION__, __LINE__);
if (is_dir($temporarySourceDir)) {
events("/bin/rm -rf {$temporarySourceDir}/*", __FUNCTION__, __LINE__);
shell_exec("/bin/rm -rf {$temporarySourceDir}/*");
}
backup_events($ID, "mysql", "INFO,{$instancename} backup END without known error");
$date_end = time();
$calculate = distanceOfTimeInWords($date_start, $date_end);
events("INFO,{$instancename} time: {$calculate}", __FUNCTION__, __LINE__);
backup_events($ID, "mysql", "INFO,{$instancename} time: {$calculate}");
}
function backup_mysql($ID)
{
$sock = new sockets();
$unix = new unix();
$date_start = time();
$mysqlhotcopy = $unix->find_program("mysqlhotcopy");
$email_spacer = "==========================================";
if ($mysqlhotcopy == null) {
backup_events($ID, "mysql", "ERROR, unable to stat mysqlhotcopy");
if (is_file($unix->find_program("mysqldump"))) {
backup_events($ID, "mysql", "INFO, switch to mysqldump processing");
return backup_mysql_oldway($ID);
}
events("ERROR, unable to stat mysqlhotcopy", __FUNCTION__, __LINE__);
send_email_events("Backup Task {$ID}:: Unable to backup mysql datas ", "ERROR, unable to stat mysqlhotcopy", "backup");
return false;
}
$array = backup_mysql_databases_list($ID);
if (!is_array($array)) {
events("ERROR, unable to get databases list", __FUNCTION__, __LINE__);
send_email_events("Backup Task {$ID}:: Unable to backup mysql datas ", "ERROR, unable to get databases list", "backup");
backup_events($ID, "mysql", "ERROR, unable to get databases list", __LINE__);
return false;
}
$q = new mysql();
if ($q->mysql_password != null) {
$password = "******";
}
if ($q->mysql_admin != null) {
$user = "******";
}
$temporarySourceDir = $sock->GET_INFO("ExecBackupTemporaryPath");
if ($temporarySourceDir == null) {
$temporarySourceDir = "/home/mysqlhotcopy";
}
$temporarySourceDir = "{$temporarySourceDir}/mysql";
events("temporarySourceDir has ExecBackupTemporaryPath token was \"{$temporarySourceDir}\"", __FUNCTION__, __LINE__);
events("Creating {$temporarySourceDir}", __FUNCTION__, __LINE__);
@mkdir($temporarySourceDir, 0666, true);
if (!is_dir($temporarySourceDir)) {
events("Creating Unable to backup mysql datas ", "ERROR, {$temporarySourceDir} permission denied or no such file or directory", __FUNCTION__, __LINE__);
send_email_events("Backup Task {$ID}:: Unable to backup mysql datas ", "ERROR, {$temporarySourceDir} permission denied or no such file or directory", "backup");
backup_events($ID, "mysql", "ERROR, {$temporarySourceDir} permission denied or no such file or directory");
return;
}
backup_events($ID, "mysql", "INFO, using {$temporarySourceDir} for temp backup");
while (list($num, $line) = each($array)) {
if (trim($line) == null) {
continue;
}
$database_name = trim(basename($line));
if (strtolower($database_name) == "log") {
events("skipping database \"{$database_name}\"", __FUNCTION__, __LINE__);
backup_events($ID, "mysql", "INFO, mysqlhotcopy skip log database", __LINE__);
continue;
}
if (strtolower($database_name) == "mysql") {
events("skipping database \"{$database_name}\"", __FUNCTION__, __LINE__);
backup_events($ID, "mysql", "INFO, mysqlhotcopy skip mysql database", __LINE__);
continue;
}
backup_events($ID, "mysql", "INFO, mysqlhotcopy database ({$database_name}) stored in {$line} -> {$temporarySourceDir}");
$mysqlhotcopy_command = "{$mysqlhotcopy} --addtodest{$user}{$password} {$database_name} {$temporarySourceDir} 2>&1";
events("\"{$mysqlhotcopy_command}\"", __FUNCTION__, __LINE__);
exec($mysqlhotcopy_command, $results);
while (list($num_line, $evenement) = each($results)) {
if (preg_match("#No space left on device#", $evenement)) {
events("ERROR, backup No space left on device ({$temporarySourceDir})", __FUNCTION__, __LINE__);
backup_events($ID, "mysql", "ERROR, backup No space left on device ({$temporarySourceDir})\n" . implode("\n", $results));
if (is_dir($temporarySourceDir)) {
shell_exec("/bin/rm -rf {$temporarySourceDir}/*");
}
return;
}
events("{$evenement}", __FUNCTION__, __LINE__);
if (preg_match("#failed:#", $evenement)) {
events("ERROR, database: \"{$database_name}\" ({$evenement})", __FUNCTION__, __LINE__);
backup_events($ID, "mysql", "ERROR, database: \"{$database_name}\" ({$evenement})");
$fulltext = @implode("\n", $results);
send_email_events("Backup Task {$ID}:: database: \"{$database_name}\" failed to backup ", "{$email_spacer}\n{$mysqlhotcopy_command}{$email_spacer}\nERROR:{$email_spacer}\n{$evenement}\n{$email_spacer}\n{$fulltext}", "backup");
}
}
backup_events($ID, "mysql", "INFO, backup {$database_name}\n" . implode("\n", $results), __LINE__);
if (strtolower($database_name) == "zarafa") {
events("zarafa database -> backup_mysql_database_mysqldump({$ID},zarafa,{$temporarySourceDir})", __FUNCTION__, __LINE__);
backup_mysql_database_mysqldump($ID, "zarafa", $temporarySourceDir);
}
}
backup_events($ID, "mysql", "INFO, Send mysql backup to the \n" . implode("\n", $results));
events("Create directory \"{$GLOBALS["MOUNTED_PATH_FINAL"]}/mysql\"", __FUNCTION__, __LINE__);
backup_mkdir("{$GLOBALS["MOUNTED_PATH_FINAL"]}/mysql");
backup_copy("{$temporarySourceDir}/*", "mysql", $ID);
backup_events($ID, "mysql", "INFO, backup remove content of {$temporarySourceDir}/*");
events("INFO, backup remove content of {$temporarySourceDir}/*", __FUNCTION__, __LINE__);
if (is_dir($temporarySourceDir)) {
events("/bin/rm -rf {$temporarySourceDir}/*", __FUNCTION__, __LINE__);
shell_exec("/bin/rm -rf {$temporarySourceDir}/*");
}
backup_events($ID, "mysql", "INFO, backup END without known error");
$date_end = time();
$calculate = distanceOfTimeInWords($date_start, $date_end);
events("INFO, time: {$calculate}", __FUNCTION__, __LINE__);
backup_events($ID, "mysql", "INFO, time: {$calculate}");
}
