backup mysql database using c#

altafmohd

i m providing code which i am running and getting exception plz help in this regard thanx .... :) public void Backup() { // Process.Start("IExplore.exe"); try { DateTime Time = DateTime.Now; int year = Time.Year; int month = Time.Month; int day = Time.Day; int hour = Time.Hour; int minute = Time.Minute; int second = Time.Second; int millisecond = Time.Millisecond; //Save file to C:\ with the current date as a filename string path; path = "C:\\MySqlBackup" + year + "-" + month + "-" + day + "-" + hour + "-" + minute + "-" + second + "-" + millisecond + ".sql"; StreamWriter file = new StreamWriter(path); ProcessStartInfo psi = new ProcessStartInfo(); psi.FileName = "mysqldump"; psi.RedirectStandardInput = false; psi.RedirectStandardOutput = true; psi.Arguments = string.Format(@"-u{0} -p{1} -h{2} {3}", "root","123456","localhost","userdb"); psi.UseShellExecute = false; Process process = Process.Start(psi); ///here is exception coming string output; output = process.StandardOutput.ReadToEnd(); file.WriteLine(output); process.WaitForExit(); file.Close(); process.Close(); } catch (IOException ex) { MessageBox.Show("Error , unable to backup!"); } } but when i run this code it is providing me runtime eroor exception ........".The system cannot find the file specified " at the line Process process = Process.Start(psi);

Wayne Gaylard

You need to supply the full path when assigning the FileName to your ProcessStartInfo object as well as the extension. i.e

psi.FileName = @"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqldump.exe";

Next time please put your code into a code block (use the code link above the input box and select your language) as this makes it much easier to read through your quaestion.

When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman

Abhinav S

Try after adding mysqldump to environment variables (along with the path to it).

altafmohd

thank u very much sir ..........i am student and new i want to learn a lot from here

Wayne Gaylard

Glad to help

When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman

altafmohd

sir i am devloping a project mysql query browser .....so i will need you in future ....i hope you will be for my help .....if you have facebook account plz tell me i want to conncet wid you...thanx in advance

altafmohd

thank u sir ho gya :)

Pete OHanlon

A few things. 1. Unless somebody is really stupid and wants to attract a lot of spam, they tend not to give personal information out on the forums, especially to someone they don't know. 2. We are more than happy to help somebody with problems, but nobody on this forum has the time to start offering one to one help. 3. You'll find that we are much more willing to help people if they don't use text speak. It's deeply irritating to those of us who enjoy the full use of the keyboard.

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility

altafmohd

OK SIR :)

Abhinav S

altafmohd wrote:

ho gya

Just for the benefit of the English community, this means "Its done". You might want to post in the GIT[^] if you want to use Hindi as your means to ask questions. Also, always vote if it helps.

altafmohd

ok sir ....and thank you :)

PIEBALDconsult

No idea, but this:

DateTime Time = DateTime.Now;
int year = Time.Year;
int month = Time.Month;
int day = Time.Day;
int hour = Time.Hour;
int minute = Time.Minute;
int second = Time.Second;
int millisecond = Time.Millisecond;

//Save file to C:\ with the current date as a filename
string path;
path = "C:\\MySqlBackup" + year + "-" + month + "-" + day +
"-" + hour + "-" + minute + "-" + second + "-" + millisecond + ".sql";

can be reduced to:

string path = System.String.Format ( @"C:\MySqlBackup{0:yyyy-MM-dd-HH-mm-ss-fff}.sql" , System.DateTime.Now ) ;

altafmohd

sir i want to provide path through " open file dialog box " ...how can i get the path where i want to save my backup file using this dialog box ...plz help thanx in advance .

altafmohd

sir i want to provide path through " open file dialog box "
...how can i get the path where i want to save my backup file using this dialog box ...plz help thanx in advance

Wayne Gaylard

Use a FolderBrowserDialog[^].

When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman

altafmohd

thank you :)