Python: LOAD DATA INFILE mySQL

Question

I try to import data into a mySQL database using Python, but I can't get it to work. I don't get any errors it looks as if everything is working OK, but the text file never gets imported.

I can import the text file just fine if I do it manually via the mysql command line in Terminal. What am I doing wrong?

imoprt mysql.connector
cnx = mysql.connector.connect(user ='user1', password ='12345', host ='127.0.0.1', database ='stockStatus')
cursor = cnx.cursor()
cursor.execute('use stockStatus')
cursor.execute('truncate table products')
cursor.execute("LOAD DATA INFILE '/Path/products.txt' INTO TABLE products IGNORE 1 LINES")
cnx.close()

you can also switch to mysql connector python v2.0.1 which has LOCAL INFILE enable by default — Peeyush
– Peeyush, Commented Sep 30, 2014 at 15:56
Ok, I think the problem is you are not doing cnx.commit() at the end. By default autocommit is set to False, there fore you have to explicitly call commit, or make the connection with autocommit=True — Peeyush
– Peeyush, Commented Oct 1, 2014 at 7:22

mhawke · Accepted Answer · 2014-09-30 14:52:23Z

0

Try using double quotes around the input file name:

cursor.execute('LOAD DATA INFILE "/Path/products.txt" INTO TABLE products IGNORE 1 LINES')

answered Sep 30, 2014 at 14:52

mhawke

87.5k10 gold badges122 silver badges142 bronze badges

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

1 Comment

elfving Over a year ago

No, that didn't do it.

Collectives™ on Stack Overflow

Python: LOAD DATA INFILE mySQL

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related