十年河东，十年河西，莫欺少年穷
学无止境，精益求精
1、备份主服务器数据库并压缩
public void DbBack()
{
var bakname = @"ChargeDB_" + DateTime.Now.ToString("yyyyMMdd") + ".bak";
string filepath = @"D:\dbback\" + bakname;
if (File.Exists(filepath))
{
File.Delete(filepath);
}
string sql = @"declare @date nvarchar(10)
set @date = CONVERT(nvarchar(10),getdate(),112)
declare @path nvarchar(250)
set @path = 'D:\dbback\'
declare @db_filename nvarchar(150)
set @db_filename = @path + 'ChargeDB_'+@date+'.bak'
backup database ChargeDB TO DISK=@db_filename ";
DataRepository.ExecuteCommand(sql);
//压缩文件 供备份服务器下载
var dbpath = @"D:\dbback\ChargeDB_" + DateTime.Now.ToString("yyyyMMdd") + ".bak";
var zippath = @"D:\dbback\ChargeDB_" + DateTime.Now.ToString("yyyyMMdd") + ".zip";
if (File.Exists(dbpath))
{
Console.WriteLine("存在数据备份文件");
ZipUtility zip = new ZipUtility();
zip.ZipFile(dbpath, zippath, 2, 2048);
}
}
View Code
2、从服务器解压缩并还原
static void Main(string[] args)
{
var zippath = @"C:\dbback";
var zipname = @"ChargeDB_" + DateTime.Now.ToString("yyyyMMdd") + ".zip";
var bakname = @"ChargeDB_" + DateTime.Now.ToString("yyyyMMdd") + ".bak";
FileLoad(zipname, zippath);
//
ZipUtility zip = new ZipUtility();
zip.UnZip(zippath+@"\"+ zipname, zippath);
Console.WriteLine("UnZipOVER");
RestoreDataBase("ChargeDB", zippath+@"\" + bakname);
Console.WriteLine(" RestoreDataBaseOver");
Console.Read();
}
/// <summary>
/// 下载文件
/// </summary>
/// <param name="fileName">客户端保存的文件名</param>
/// <param name="filePath">保存的文件夹路径</param>
/// <returns></returns>
public static void FileLoad(string fileName, string filePath)
{
//判断保存的文件夹是否存在
if (!Directory.Exists(filePath))
{
//不存在则创建
Directory.CreateDirectory(filePath);
}
//System.Net 中的验证和下载方法
WebClient client = new WebClient();
client.Credentials = CredentialCache.DefaultCredentials;
client.DownloadFile("https://chengxiangzhineng.com/dbsite/ChargeDB_20240605.zip", filePath + "\\" + fileName);
Console.WriteLine("下载完成");
}
public static void RestoreDataBase(string dataBaseName, string dataBaseBackupFile)
{
var CommandText = string.Format(@"USE [master]
ALTER DATABASE {0}
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
restore database {0} from DISK='{1}'
WITH REPLACE
ALTER DATABASE {0}
SET MULTI_USER;", dataBaseName, dataBaseBackupFile);
DataRepository.ExecuteCommand(CommandText);
}
View Code
3、帮助类
using ICSharpCode.SharpZipLib.Checksum;
using ICSharpCode.SharpZipLib.Zip;
using System;
using System.Collections.Generic;
using System.IO;
using System.Text;
namespace swapCommon
{
public class ZipUtility
{
/// <summary>
/// 所有文件缓存
/// </summary>
List<string> files = new List<string>();
/// <summary>
/// 所有空目录缓存
/// </summary>
List<string> paths = new List<string>();
/// <summary>
/// 压缩单个文件
/// </summary>
/// <param name="fileToZip">要压缩的文件</param>
/// <param name="zipedFile">压缩后的文件全名</param>
/// <param name="compressionLevel">压缩程度，范围0-9，数值越大，压缩程序越高</param>
/// <param name="blockSize">分块大小</param>
public void ZipFile(string fileToZip, string zipedFile, int compressionLevel, int blockSize)
{
if (!System.IO.File.Exists(fileToZip))//如果文件没有找到，则报错
{
throw new FileNotFoundException("The specified file " + fileToZip + " could not be found. Zipping aborderd");
}
FileStream streamToZip = new FileStream(fileToZip, FileMode.Open, FileAccess.Read);
FileStream zipFile = File.Create(zipedFile);
ZipOutputStream zipStream = new ZipOutputStream(zipFile);
ZipEntry zipEntry = new ZipEntry(fileToZip);
zipStream.PutNextEntry(zipEntry);
zipStream.SetLevel(compressionLevel);
byte[] buffer = new byte[blockSize];
int size = streamToZip.Read(buffer, 0, buffer.Length);
zipStream.Write(buffer, 0, size);
try
{
while (size < streamToZip.Length)
{
int sizeRead = streamToZip.Read(buffer, 0, buffer.Length);
zipStream.Write(buffer, 0, sizeRead);
size += sizeRead;
}
}
catch (Exception ex)
{
GC.Collect();
throw ex;
}
zipStream.Finish();
zipStream.Close();
streamToZip.Close();
GC.Collect();
}
/// <summary>
/// 压缩目录（包括子目录及所有文件）
/// </summary>
/// <param name="rootPath">要压缩的根目录</param>
/// <param name="destinationPath">保存路径</param>
/// <param name="compressLevel">压缩程度，范围0-9，数值越大，压缩程序越高</param>
public void ZipFileFromDirectory(string rootPath, string destinationPath, int compressLevel)
{
GetAllDirectories(rootPath);
/* while (rootPath.LastIndexOf("\\") + 1 == rootPath.Length)//检查路径是否以"\"结尾
{
rootPath = rootPath.Substring(0, rootPath.Length - 1);//如果是则去掉末尾的"\"
}
*/
//string rootMark = rootPath.Substring(0, rootPath.LastIndexOf("\\") + 1);//得到当前路径的位置，以备压缩时将所压缩内容转变成相对路径。
string rootMark = rootPath + "\\";//得到当前路径的位置，以备压缩时将所压缩内容转变成相对路径。
Crc32 crc = new Crc32();
ZipOutputStream outPutStream = new ZipOutputStream(File.Create(destinationPath));
outPutStream.SetLevel(compressLevel); // 0 - store only to 9 - means best compression
foreach (string file in files)
{
FileStream fileStream = File.OpenRead(file);//打开压缩文件
byte[] buffer = new byte[fileStream.Length];
fileStream.Read(buffer, 0, buffer.Length);
ZipEntry entry = new ZipEntry(file.Replace(rootMark, string.Empty));
entry.DateTime = DateTime.Now;
entry.Size = fileStream.Length;
fileStream.Close();
crc.Reset();
crc.Update(buffer);
entry.Crc = crc.Value;
outPutStream.PutNextEntry(entry);
outPutStream.Write(buffer, 0, buffer.Length);
}
this.files.Clear();
foreach (string emptyPath in paths)
{
ZipEntry entry = new ZipEntry(emptyPath.Replace(rootMark, string.Empty) + "/");
outPutStream.PutNextEntry(entry);
}
this.paths.Clear();
outPutStream.Finish();
outPutStream.Close();
GC.Collect();
}
/// <summary>
/// 取得目录下所有文件及文件夹，分别存入files及paths
/// </summary>
/// <param name="rootPath">根目录</param>
private void GetAllDirectories(string rootPath)
{
string[] subPaths = Directory.GetDirectories(rootPath);//得到所有子目录
foreach (string path in subPaths)
{
GetAllDirectories(path);//对每一个字目录做与根目录相同的操作：即找到子目录并将当前目录的文件名存入List
}
string[] files = Directory.GetFiles(rootPath);
foreach (string file in files)
{
this.files.Add(file);//将当前目录中的所有文件全名存入文件List
}
if (subPaths.Length == files.Length && files.Length == 0)//如果是空目录
{
this.paths.Add(rootPath);//记录空目录
}
}
/// <summary>
/// 解压缩文件(压缩文件中含有子目录)
/// </summary>
/// <param name="zipfilepath">待解压缩的文件路径</param>
/// <param name="unzippath">解压缩到指定目录</param>
/// <returns>解压后的文件列表</returns>
public List<string> UnZip(string zipfilepath, string unzippath)
{
//解压出来的文件列表
List<string> unzipFiles = new List<string>();
//检查输出目录是否以“\\”结尾
if (unzippath.EndsWith("\\") == false || unzippath.EndsWith(":\\") == false)
{
unzippath += "\\";
}
ZipInputStream s = new ZipInputStream(File.OpenRead(zipfilepath));
ZipEntry theEntry;
while ((theEntry = s.GetNextEntry()) != null)
{
string directoryName = Path.GetDirectoryName(unzippath);
string fileName = Path.GetFileName(theEntry.Name);
//生成解压目录【用户解压到硬盘根目录时，不需要创建】
if (!string.IsNullOrEmpty(directoryName))
{
Directory.CreateDirectory(directoryName);
}
if (fileName != String.Empty)
{
//如果文件的压缩后大小为0那么说明这个文件是空的,因此不需要进行读出写入
if (theEntry.CompressedSize == 0)
continue;
//解压文件到指定的目录
directoryName = Path.GetDirectoryName(unzippath + fileName);
//建立下面的目录和子目录
Directory.CreateDirectory(directoryName);
//记录导出的文件
unzipFiles.Add(unzippath + fileName);
FileStream streamWriter = File.Create(unzippath + fileName);
int size = 2048;
byte[] data = new byte[2048];
while (true)
{
size = s.Read(data, 0, data.Length);
if (size > 0)
{
streamWriter.Write(data, 0, size);
}
else
{
break;
}
}
streamWriter.Close();
}
}
s.Close();
GC.Collect();
return unzipFiles;
}
public string GetZipFileExtention(string fileFullName)
{
int index = fileFullName.LastIndexOf(".");
if (index <= 0)
{
throw new Exception("The source package file is not a compress file");
}
//extension string
string ext = fileFullName.Substring(index);
if (ext == ".rar" || ext == ".zip")
{
return ext;
}
else
{
throw new Exception("The source package file is not a compress file");
}
}
}
}
View Code
注：当主服务器备份时，可通过某种通知机制，告诉从服务器进行下载，解压缩并还原。保持备份/还原同步
over
标签：string,buffer,压缩,sqlserver,rootPath,Length,new,服务器,bak From： https://www.cnblogs.com/chenwolong/p/18233123