日期:2014-05-16 浏览次数:20518 次
1:异步备份MySql数据库
2:如果备份成功,有耗时提示,并提供备份文件下载;如果备份失败,则提示错误信息。
string strConn = "server=localhost;database=AgrBankBox3;uid=root;pwd=888888;charset=gb2312;";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DeleteOldFile();
try
{
lblMsg.Text = "";
if (!TestConnection())
{
return;
}
BackupData();
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
}
void mb_ProgressCompleted(object sender, MySqlBackupCompleteArg e)
{
if (e.CompletedType == MySqlBackupCompleteArg.CompleteType.Error)
{
Response.Write(e.ExceptionInfo.ToString());
}
else
{
Session["resultmsg"] = "耗时: " + e.TimeUsed.Hours + " 时 " + e.TimeUsed.Minutes + " 分 " + e.TimeUsed.Seconds + " 秒 " + e.TimeUsed.Milliseconds + " 毫秒.";
Response.Redirect("BackupComplete.aspx");
}
}
void DeleteOldFile()
{
string timeNow = DateTime.Now.AddMinutes(-15).ToString("yyyyMMddHHmmss");
long iTimeNow = Convert.ToInt64(timeNow);
string[] oldFiles = System.IO.Directory.GetFiles(Server.MapPath("~/dumpfiles"));
foreach (string s in oldFiles)
{
if (!s.EndsWith("sql"))
{
continue;