如何将本地服务器（即PC上）的Windows桌面应用程序的mysql数据库与实时服务器同步 [英] How to synchronize mysql database of windows desktop application on local server(i.e on the pc) with the live server

问题描述

我正在visual studio 2012上创建一个带有前端c＃.net和后端MySql数据库的Windows桌面应用程序。



我的主数据库离线，我想要在实时服务器上备份。



怎么可能？



有什么方法可以采取在具有离线mysql数据库的Windows桌面应用程序的实时服务器上备份。



我尝试过：



i绝对不知道怎么做。我已经读过它可以用mysqldump完成，但我想它是针对Linux O / S而不是针对windows。

i am creating a windows desktop application on visual studio 2012 with front end c#.net and back end MySql database.

My Master database is offline and i want to take backup on live server.

how it is possible?

what are the ways to take backup on live server for windows desktop application having offline mysql database.?

What I have tried:

i have absolutely no idea of how to do it. i had read that it can be done with mysqldump but i guess it is for linux O/S and not for windows.

推荐答案

你可以使用下面的代码来获取备份

you can use following code to take a backup

private void Backup()
{
    string constring = "server=localhost;user=root;pwd=qwerty;database=test;";
    string file = "C:\\backup.sql";
    using (MySqlConnection conn = new MySqlConnection(constring))
    {
        using (MySqlCommand cmd = new MySqlCommand())
        {
            using (MySqlBackup mb = new MySqlBackup(cmd))
            {
                cmd.Connection = conn;
                conn.Open();
                mb.ExportToFile(file);
                conn.Close();
            }
        }
    }
}

这篇关于如何将本地服务器（即PC上）的Windows桌面应用程序的mysql数据库与实时服务器同步的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！