How to Backup Automatically Mysql in C# coding?

Question

I want to backup my Database in MySQL for Each time Application is Closing.

I googled for the DUMP in MySQL. but i got only php or batch file programs.

Any one know how to Backup Automatically Mysql in C# coding?.

Or Executing Batch is the Only way. Is it possible in Winform C#?.

My Connection String is -

connectionString="server=192.168.1.100;User Id=root;database=mcs_sps;Persist Security Info=True"

Thanks in Advance!.

cgon · Accepted Answer · 2011-08-01 20:56:48Z

2

There are good samples and a good best practice in the following link: http://forums.mysql.com/read.php?47,214274,214274#msg-214274

I think your best shot is that aL3891 suggests unless you do not want to pay . If you want to pay for this simple task check out these links:

answered Aug 1, 2011 at 20:56

cgon

1,9912 gold badges24 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

aL3891 · Accepted Answer · 2011-08-01 19:17:55Z

2

Using the Process class you can start an instance of Mysqldump or Mysqlhotcopy, command-line programs for dumping an entire mysql database.

answered Aug 1, 2011 at 19:17

aL3891

6,3053 gold badges35 silver badges39 bronze badges

Simple and reliable. Can't lose with that.

Aishwarya Shiva · Accepted Answer · 2012-09-24 10:10:34Z

1

I tried it in my application and it works perfectly

answered Sep 24, 2012 at 10:10

Aishwarya Shiva

3,41616 gold badges61 silver badges113 bronze badges