MySQL Backup Database in C#

Question

I found a query from HERE on how to backup the database but it is not working and it throws an error. Any help please. TIA

CODE:

using MySql.Data.MySqlClient;
public bool BackupDatabase(string filename = "")
{
    bool _isExecuted = false;

    if (filename == "")
    {
        filename = string.Format("{0}/db_{1:MMddyyyyHHmmss}.sql", Environment.GetFolderPath(Environment.SpecialFolder.Desktop), DateTime.Now);
    }

    string _queryBackup = string.Format("mysqldump -u '{0}' -p '{1}' '{2}' > '{3}'", DatabaseUsername, DatabasePassword, DatabaseName, filename);         
    using (MySqlConnection con = new MySqlConnection(ConnectionString))
    {
        try
        {
            con.Open();
            MySqlCommand cmd = new MySqlCommand(_queryBackup, con);

            cmd.ExecuteNonQuery();
            _isExecuted = true;
        }
        catch (Exception ex)
        {
            string _x = ex.Message;
        }
    }

    return _isExecuted;
}

ERROR:

_x contains this error

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqldump -u 'root' -p 'usbw' 'my_database_name' > 'C:\Users\DesktopName\Desktop\db_08242012164022.sql' at line 1"

You can consider MySqlBackup.NET as alternative to MySqlDump. Read more: github.com/MySqlBackupNET/MySqlBackup.Net — mjb
– mjb, Commented May 5, 2018 at 1:02

tomsv · Accepted Answer · 2012-08-24 08:44:18Z

1

Your _queryBackup is not an sql query string but a string to run from the system, as if you run it from the cmd console.

Here is some code to run a command such as yours from C#

  var startInfo = new ProcessStartInfo(command, parameterstring);
  startInfo.RedirectStandardError = true;
  startInfo.CreateNoWindow = true;
  startInfo.RedirectStandardOutput = true;
  startInfo.UseShellExecute = false;
  startInfo.ErrorDialog = false;
  Process process = Process.Start(startInfo);
  StreamReader stdoutSR = process.StandardOutput;
  string stdout = stdoutSR.ReadToEnd();
  StreamReader stderrSR = process.StandardError;
  string stderr = stderrSR.ReadToEnd();

answered Aug 24, 2012 at 8:44

tomsv

7,2878 gold badges58 silver badges90 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Vincent Dagpin Over a year ago

ahhh.. so, is there any sql query string to backup the database? so the given method is applicable?

Collectives™ on Stack Overflow

MySQL Backup Database in C#

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related