Backup A mysql database betwwen two dates using C#.Net

Question

0.00/5 (No votes)

See more:

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.

Posted 17-Dec-13 4:18am

binoyvijayan

Add a Solution

Comments

Ron Beyer 17-Dec-13 10:28am

What have you tried? Where are you stuck?

binoyvijayan 17-Dec-13 10:32am

void Backup()
{
string constr = "server=localhost;user=root;pwd=qwerty;database=test;";
string file = "C:\\MyDumpFile.sql";
MySqlBackup mb = new MySqlBackup(constr);
mb.ExportInfo.FileName = file;
mb.Export();
}

Maciej Los 17-Dec-13 16:36pm

It is a code dump; source: http://stackoverflow.com/questions/12311492/backing-up-database-in-mysql-using-c-sharp[^]!

binoyvijayan 17-Dec-13 10:31am

I am trying with the MySqlBackUp class. But it has no way to specify the date

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Answer 1 · 2013-12-17T05:32:00

Solution 1

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.

Posted 17-Dec-13 5:32am

Dave Kreskowiak

Comments

binoyvijayan 18-Dec-13 4:08am

Hi,
Thanks for your Reply,
Let me explain little,

I am working on a desktop application, its a database management tool.The user specify the minimum memory space level.The code check the drive that the database is stored, when the free space of the drive is less than the specified minimum memory space .then we persist a certain period data to same drive and remaining backup to another media (flash drive, external hdd etc). The Persisting database period is specified by the user.
Now I think you get my situation..
Thanks ...
Please help me

Dave Kreskowiak 18-Dec-13 12:34pm

Yes, I understand, and that doesn't changethe answer. What you're talking about is not backup, but archiving old data. The two concepts are not the the same.

Maciej Los · Answer 2 · 2013-12-17T10:49:00

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:

SQL

INSERT INTO DestinationDatabase (Field1, Field2, Field3, ..., FieldN)
SELECT (Field1, Field2, Field3, ..., FieldN)
FROM SourceDatabase
WHERE DateField BETWEEN @date1 AND @date2