使用C#.Net备份两个日期的mysql数据库 [英] Backup A mysql database betwwen two dates using C#.Net
本文介绍了使用C#.Net备份两个日期的mysql数据库的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我必须将mysql数据库备份到某个驱动器。用户选择两个日期,我想在这两个日期之间备份数据库。我在winform c#应用程序中工作。
感谢您的时间和考虑。
解决方案
备份没有日期规范,所以你的问题没有任何意义。您可以备份整个数据库,表格及其中的所有数据,也可以不创建备份。
我认为你所指的是什么将数据范围之间的记录复制到另一个数据库中的另一个表。
到目前为止,备份MySQL数据库的最佳解决方案是: MySqlBackup.NET - 用于C#,VB.NET,ASP.NET的MySQL备份解决方案 [ ^ ]
但我想,你需要使用 INSERT [ ^ ]和/或更新 [ ^ ] stetemens。
这将是一些东西类似于以下查询:
INSERT INTO DestinationDatabase(Field1,Field2,Field3,...,FieldN)
SELECT (Field1,Field2,Field3,...,FieldN)
FROM SourceDatabase
WHERE DateField BETWEEN @ date1 AND @ date2
Hi,
I have to backup a mysql database to certain drive. The user select two dates, I want to backup the database between this two date . I am working in winform c# application.
Thanks for your time and consideration.
解决方案
Backups don't have a date specification so your question doesn't make any sense. You either take a backup of the entire database, tables and all data in them, or you're not creating a backup.
What I think you're refering to is copying records between data ranges to a another table in another database.
So far the best solution to backup MySQL database is here: MySqlBackup.NET - MySQL Backup Solution for C#, VB.NET, ASP.NET[^]
But i think, you need to use INSERT[^] and/or UPDATE[^] stetemens.
It would be something similar to below query:
INSERT INTO DestinationDatabase (Field1, Field2, Field3, ..., FieldN) SELECT (Field1, Field2, Field3, ..., FieldN) FROM SourceDatabase WHERE DateField BETWEEN @date1 AND @date2
这篇关于使用C#.Net备份两个日期的mysql数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文