C# MySQL 数据库恢复

发布于 2024-10-08 01:08:02 字数 954 浏览 1 评论 0原文

我正在尝试使用 C# 代码从转储文件恢复 MySQL 数据库数据。

我应该执行以下命令： mysql --verbose --user=root --password=qwerty123456 测试 < C:\Users\Default\testing.SQL

我知道 C# 无法识别“<”符号所以我尝试了几种方法但仍然不起作用。有人能帮我解决这个问题吗？我想使用 C# 代码将所有数据库数据恢复到 MySQL。

提前致谢。

            Process process = new Process();
            process.StartInfo.FileName = @"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exe";
            process.StartInfo.Arguments = @"--verbose --user=root --password=qwerty123456 test";
            process.StartInfo.UseShellExecute = false;
            process.StartInfo.RedirectStandardOutput = true;
            process.StartInfo.RedirectStandardInput = true;
            process.StartInfo.RedirectStandardError = true;
            process.StartInfo.CreateNoWindow = true;
            process.Start();

            StreamReader sr = process.StandardOutput;
            sr = File.OpenText(@"C:\Users\Default\testing.SQL");

原文

I am trying to restore MySQL database data from a dump file, using C# codes.

I am suppose to execute the following command:
mysql --verbose --user=root --password=qwerty123456 test < C:\Users\Default\testing.SQL

I know that C# doesn't recognise the "<" symbol so I tried several ways but it still did not work. Can anybody help me with this? I want to restore all my database data back into MySQL using C# codes.

Thanks in advance.

            Process process = new Process();
            process.StartInfo.FileName = @"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exe";
            process.StartInfo.Arguments = @"--verbose --user=root --password=qwerty123456 test";
            process.StartInfo.UseShellExecute = false;
            process.StartInfo.RedirectStandardOutput = true;
            process.StartInfo.RedirectStandardInput = true;
            process.StartInfo.RedirectStandardError = true;
            process.StartInfo.CreateNoWindow = true;
            process.Start();

            StreamReader sr = process.StandardOutput;
            sr = File.OpenText(@"C:\Users\Default\testing.SQL");

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

睫毛上残留的泪 2024-10-15 01:08:03

如果您只需设置 UseShellExecute = true，< 处理应该 (IIRC) 没问题。

但是，如果您确实想避免 shell 执行，< 是一个输入 - 您应该将文件写入 StandardInput。我可能会单独保留 StandardOutput （如果您不主动想要输出，请设置 RedirectStandardOutput = false）。

未经测试，但也许：（

        using(var stdin = process.StandardInput)
        using(var reader = File.OpenText(@"C:\Users\Default\testing.SQL")) {
            string line;
            while((line = reader.ReadLine()) != null) {
                stdin.WriteLine(line);
            }
            stdin.Close();
        }

应该逐行输入文件）

The < handling should (IIRC) be OK if you simply set UseShellExecute = true.

However, if you really want to avoid the shell exec, < is an input - you should be writing the file to StandardInput. I'l probably leave StandardOutput alone (set RedirectStandardOutput = false if you don't actively want the output).

Untested, but maybe:

        using(var stdin = process.StandardInput)
        using(var reader = File.OpenText(@"C:\Users\Default\testing.SQL")) {
            string line;
            while((line = reader.ReadLine()) != null) {
                stdin.WriteLine(line);
            }
            stdin.Close();
        }

(which should pipe in the file line by line)

回复收藏 0 原文

~没有更多了~