In few months ago I was finding a way to backup mysql database. After those time again I found some intersting code part from web. I really thanks for first owner of this amazing code. I will put it below. But first, I must said one thing I'm just unsure at line : 16 therefore we need expertiese ideas to prove this codes 100% work.
Dim file As String sfd.Filter = "SQL Dump File (*.sql)|*.sql|All files (*.*)|*.*" sfd.FileName = "Database Backup " + DateTime.Now.ToString("yyyy-MM-dd HH-mm-ss") + ".sql" If sfd.ShowDialog = DialogResult.OK Then file = sfd.FileName Dim myProcess As New Process() myProcess.StartInfo.FileName = "cmd.exe" myProcess.StartInfo.UseShellExecute = False myProcess.StartInfo.WorkingDirectory = "C:\Program Files (x86)\MySQL\MySQL Server 5.0\bin" myProcess.StartInfo.RedirectStandardInput = True myProcess.StartInfo.RedirectStandardOutput = True myProcess.Start() Dim myStreamWriter As StreamWriter = myProcess.StandardInput Dim mystreamreader As StreamReader = myProcess.StandardOutput myStreamWriter.WriteLine("mysqldump -u root --password=mysql _-h localhost ""moneycs"" > """ + file + """ ") myStreamWriter.Close() myProcess.WaitForExit() myProcess.Close() MsgBox("Backup Created Successfully!", MsgBoxStyle.Information, "Backup")
Please give your advice for line no 16 code : is it true or false ? if false please correct it for thousand of coders.