How to take backup and restore of a MySQL DataBase using c#.net

See more:

MySQL

Hi........

I am doing a windows application in that i used MySQL as back end.I want to take the backup of Database by writing code in c#.net. If any body knows please send me that code. I googled but no use. I found one code but but its coming for 1st table only. I wan the whole Database.
This is the code which i used...

try
{
  DateTime backupTime = DateTime.Now;
  int year = backupTime.Year;
  int month = backupTime.Month;
  int day = backupTime.Day;
  int hour = backupTime.Hour;
  int minute = backupTime.Minute;
  int second = backupTime.Second;
  int ms = backupTime.Millisecond;

  String tmestr = backupTime.ToString();
  tmestr = "D:\\" + year + "-" + month + "-" + day + "-" + hour + "-" + minute + ".sql";
  StreamWriter file = new StreamWriter(tmestr);
  ProcessStartInfo proc = new ProcessStartInfo();
  string cmd = string.Format(@"-u{0} -p{1} -h{2} {3} ", "root", "sa", "localhost", "employee", "backup.sql");
  proc.FileName = @"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqldump";
  proc.RedirectStandardInput = false;
  proc.RedirectStandardOutput = true;
  proc.Arguments = cmd;//"-u root -p smartdb > testdb.sql";
  proc.UseShellExecute = false;
  Process p = Process.Start(proc);
  string res;
  res = p.StandardOutput.ReadToEnd();
  file.WriteLine(res);
  p.WaitForExit();
  file.Close();
  MessageBox.Show("Backup Done");
}
catch (IOException ex)
{
  MessageBox.Show("Disk full or other IO error , unable to backup!");
}

But its coming for the 1st table only...
I want the whole database.

Thanks in advance......