c# - 如何使用 C# 从 mysql 数据库导出/下载表？

Question

我想将表从 mysql 数据库导出到 txt 或 csv 文件，就像在 phpmyadmin 中一样。我目前使用下面的代码，但在程序运行几个小时后，它会抛出“试图读取过去的流”错误。

MySqlConnection connection = new MySqlConnection(MyConString);
            MySqlCommand command = connection.CreateCommand();
            connection.Open();
            command.CommandText = "SELECT * FROM mytable";
            MySqlDataReader result = command.ExecuteReader();
                if (result != null)
                    while (result.Read())
                    {
                        string thisrow = "";
                        for (int i = 0; i < result.FieldCount; i++)
                            thisrow += result.GetValue(i).ToString() + ",";
                        pass = Regex.Replace(thisrow, @"\W*", "");
                        if (!hshTable.ContainsKey(pass)) hshTable.Add(pass, pass);
                    }
            connection.Close();

是否有类似myquerystring = "LOAD DATA LOCAL INFILE 'C:/mysqltable.txt' INTO TABLE mytable FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'";

不是将文件加载到数据库，而是下载表格？

好的，我试过了

MySqlConnection connection = new MySqlConnection(MyConString);
        MySqlCommand command = connection.CreateCommand();
        connection.Open();
             myquerystring = "SELECT * INTO OUTFILE 'E:/mysqldump.csv' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' FROM mytable";
                command.CommandText = myquerystring;
                command.ExecuteNonQuery();

但它一直给我一个“拒绝用户'admin'@'myip'的访问(使用密码:是)”错误，其中 myip 实际上是我的 ip 而不是服务器，即使在 MyConString 中指定了服务器 IP。

Answer 1

你可以试试这个:

SELECT * INTO OUTFILE 't:/mysqldump.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n'
FROM mytable

请记住，MySql 进程的所有者必须具有在给定位置写入的权限。