使用asp.net和C#进行mysql数据库的增量备份 [英] incremental backup of mysql database using asp.net and c#

问题描述

晚上好，

我已经开发了一个使用asp.net的应用程序，并使用mysql作为后端的c#开发了一个应用程序.

我的应用程序根据该位置使用其数据库在不同的位置运行，数据库表和字段都相同.

我的问题是我必须提供备份和还原页面.
备份页面将为每个位置进行数据库的增量备份，然后所有备份都将放入主服务器数据库中，以便管理员可以生成报告.

请指导我该怎么做?
感谢

Good evening,

I have developed an application using asp.net and c# using mysql as backend.

My application is running in different location using their database according to that location, the database tables and field are all same.

My problem is I have to provide a backup and restore page.
The backup page will take the incremental backup of the database for every location and after that all the backups will put in main server database so that the administrator can generate the reports.

Please guide me how I will do this?
thanks

推荐答案

希望您的数据库中有适当的审核字段，
审核字段应具有

位置，
Row_Updated_on，
Row_Created_on，
Created_by，
Updated_by字段.

根据这些字段，您可以使用ASP.NET页和C#编码进行增量备份.


只需获取更新或创建日期在最后一天的数据范围内的记录即可，然后将这些记录推送到主数据库服务器

希望这会给您实现的想法.

Hope you have proper audit fields in your database,
Audit fields should have,

Location,
Row_Updated_on,
Row_Created_on,
Created_by,
Updated_by field.

Based upon these fields you can have the incremental backup using your ASP.NET pages and C# coding


Just Fetch the records where Updated_on or Created_On date is in the Range of Last Day''s data updated or created ... and push those to the Main Database Server

Hope this would give you an idea for implementing this.

这篇关于使用asp.net和C#进行mysql数据库的增量备份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！