";
$res=@mysqli_query($config['dbconnection'], "FLUSH PRIVILEGES");
$meldung=((is_object($config['dbconnection'])) ? mysqli_error($config['dbconnection']) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false));
if ($meldung!="")
{
$msg.='> MySQL-Error: '.$meldung;
}
else
{
$msg.="> Privileges were reloaded.";
}
break;
case 2: //FLUSH STATUS
$msg="> operating FLUSH STATUS
";
$res=@mysqli_query($config['dbconnection'], "FLUSH STATUS");
$meldung=((is_object($config['dbconnection'])) ? mysqli_error($config['dbconnection']) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false));
if ($meldung!="")
{
$msg.='> MySQL-Error: '.$meldung;
}
else
{
$msg.="> Status was reset.";
}
break;
case 3: //FLUSH HOSTS
$msg="> operating FLUSH HOSTS
";
$res=@mysqli_query($config['dbconnection'], "FLUSH HOSTS");
$meldung=((is_object($config['dbconnection'])) ? mysqli_error($config['dbconnection']) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false));
if ($meldung!="")
{
$msg.='> MySQL-Error: '.$meldung;
}
else
{
$msg.="> Hosts were reloaded.";
;
}
break;
case 4: //SHOW MASTER LOGS
$msg="> operating SHOW MASTER LOGS
";
$res=@mysqli_query($config['dbconnection'], "SHOW MASTER LOGS");
$meldung=((is_object($config['dbconnection'])) ? mysqli_error($config['dbconnection']) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false));
if ($meldung!="")
{
$msg.='> MySQL-Error: '.$meldung;
}
else
{
$numrows=mysqli_num_rows($res);
if ($numrows==0||$numrows===false)
{
$msg.='> there are no master log-files';
}
else
{
$msg.='> there are '.$numrows.' logfiles
';
for ($i=0; $i<$numrows; $i++)
{
$row=mysqli_fetch_row($res);
$msg.='> '.$row[0].' '.(($data_dir) ? byte_output(@filesize($data_dir.$row[0])) : '').'
';
}
}
}
break;
case 5: //RESET MASTER
$msg="> operating RESET MASTER
";
$res=@mysqli_query($config['dbconnection'], "RESET MASTER");
$meldung=((is_object($config['dbconnection'])) ? mysqli_error($config['dbconnection']) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false));
if ($meldung!="")
{
$msg.='> MySQL-Error: '.$meldung;
}
else
{
$msg.="> All Masterlogs were deleted.";
}
break;
}
echo ''.$lang['L_MYSQLSYS'].'
';
echo '';
echo '';
echo '> MySQL Dumper v'.MSD_VERSION.' - Output Console
';
echo ($msg!="") ? $msg : '> waiting for operation ...
';
echo '
';