Hi sir.
I want to take a database backup using vb.net
I am using following code:
backupBtn.Text = MessageBox.Show("Want to back up your database?", "BACK-UP DATABASE!", MessageBoxButtons.YesNo)
If backupBtn.Text = DialogResult.Yes Then
backupBtn.Text = "Backup Database"
Dim file2 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
file2 = sfd.FileName
Dim myProcess As New Process()
myProcess.StartInfo.FileName = "cmd.exe"
myProcess.StartInfo.UseShellExecute = False
myProcess.StartInfo.WorkingDirectory = "C:\xampp\mysql\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 --host=hostname --user=username --password=passwrd --silent databasename > """ + file2 + """")
myStreamWriter.Close()
myProcess.WaitForExit()
myProcess.Close()
MsgBox("Successfully created New backup", MsgBoxStyle.Information, "Backup")
End If
Else
backupBtn.Text = "Backup Database"
End If
Backup is done successfully, But command prompt is showing about 10 seconds. i dont want to show that . how to hide that? pls help me..