SQL Server - Creating Database backup application

Asked By Rajesh Madhukar on 15-Feb-07 04:34 AM
I have to create an application which takes database backup of
MySql database and generates its script file.
Can anyone give me idea how to proceed?
Rajesh Madhukar

Use Process.Start() to "shell"... - Sean Patterson replied to Rajesh Madhukar on 15-Feb-07 12:50 PM

I'd recommend creating some kind of GUI that when a button is pressed, the Process.Start() method is called to effectively "shell out" and run the mysqldump command to dump your database. What parameters you want to use is up to you, but you can have the user specify the name of the file in your GUI or timestamp it, or whatever you desire.