problem with mysql export to file in c#

Question

i have a problem with mysql+c# in mysql export operation.

FolderBrowserDialog fol=new FolderBrowserDialog();
if (fol.ShowDialog() == DialogResult.OK)
{
   string path= fol.SelectedPath;
   string sql = "SELECT * INTO OUTFILE '" + path+ "\person.csv' FIELDS TERMINATED BY',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n' FROM tpers ";
   MySqlCommand daa = new MySqlCommand(sql, conn);
   conn.Open();
   daa.ExecuteNonQuery();
   conn.Close();                              
}

for example
path = "c:\export"
but when i execute this code it doesnt export person.csv to intended path.
it creates "c:export\person.csv" file and creates this file in mysql/data folder..
can u explain the problem, and how to fix it...

Try /export/person.csv? Since this question has nothing to do with C# (or your application), you might want to ask on a MySql forum, specifically the provider of the Windows port. — Tergiver
– Tergiver, Commented Feb 19, 2011 at 17:40

namco · Accepted Answer · 2011-02-21 06:47:13Z

1

I solved this problem..

string path = fol.SelectedPath;
path = path.Replace("\\","/");
...

after this my program works correctly...

answered Feb 21, 2011 at 6:47

namco

6,41020 gold badges61 silver badges86 bronze badges

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

Comments

T.S. · Accepted Answer · 2022-08-27 04:30:12Z

0

Works for me!! In my case needed to do in c#. Used with the MySql.Data.dll v6.4.4

LOAD DATA LOCAL INFILE 'C:/Program Files/MySQL/MySQL Server 5.7/bin/test.csv' REPLACE INTO TABLE test_tmp CHARACTER SET UTF8  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\\n' IGNORE 1 LINES (field1,field2,field3,field4,field5);

edited Aug 27, 2022 at 4:30

T.S.

19.7k11 gold badges70 silver badges96 bronze badges

answered Aug 23, 2022 at 11:51

dkl

1

Collectives™ on Stack Overflow

problem with mysql export to file in c#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related