problem while importing the data from text to mysql

Question

I have used an application to import some data from a text file to mysql. I have used the following code.

try
{
   stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                               ResultSet.CONCUR_UPDATABLE);
   stmt1= (Statement) conn.createStatement();
   int deleteRows = stmt1.executeUpdate("delete  from powerdata where dateformat < dateformat_sub(now(), interval 8 month)");
   query = "LOAD DATA LOCAL INFILE \"E:\\powerdata.txt\" INTO TABLE powerdata  set dateformat=str_to_date(date, '%m/%d/%Y' '%H:%i:%s');";
   int Update= stmt.executeUpdate(query);
}

But the query to load the data from text to mysql is null. Can anybody tell me where I have made a mistake?

This code fragment appears to be missing useful context, such as the types of stmt, stmt1, query, etc; I'll wager they're something like Statement, Statement and String, but it's not obvious. Can you also rephrase the actual problem, with reference to your code if necessary? — Rob
– Rob, Commented Feb 24, 2009 at 8:47

schweerelos · Accepted Answer · 2009-03-03 22:32:03Z

1

Could it be that the problem is the \"E:\\powerdata.txt\" bit? You're escaping the quotes, but you're not escaping the backslashes. That means your query actually looks like this: LOAD DATA LOCAL INFILE "E:\powerdata.txt" INTO TABLE powerdata set dateformat=str_to_date(date, '%m/%d/%Y' '%H:%i:%s');

To fix the filename, use \"E:\\\\powerdata.txt\".

answered Mar 3, 2009 at 22:32

schweerelos

2,1892 gold badges17 silver badges25 bronze badges

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

Comments

carson · Accepted Answer · 2009-02-24 09:35:17Z

0

You probably haven't given the user you are using FILE privileges. If you look over the documentation they talk about the privileges a remote user would need to load data using LOAD DATA LOCAL INFILE. There is a good reason this is turned off so be careful if you enable it.

edited Feb 24, 2009 at 9:35

answered Feb 24, 2009 at 9:29

carson

5,7593 gold badges27 silver badges25 bronze badges

1 Comment

xyz Over a year ago

i have executed the cmd sucessfully in mysql. The problem is that i am using the java application to do this and there i am having the problem

Collectives™ on Stack Overflow

problem while importing the data from text to mysql

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related