No error but load infile in .sql file not working in python script

Question

I have .sql file which has multiple load commands as follows,

LOAD DATA LOCAL INFILE 'csvname.csv' INTO TABLE table_name FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES(....);
LOAD DATA LOCAL INFILE 'csvname.csv' INTO TABLE table_name FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES(....);

Which runs perfectly in SQL terminal but in the script I don't get any error still not loading

My code:

#db = pymysql.connect(**db_opts)
conn = pymysql.connect(rds_host, user=name, passwd=password, db=db_name, connect_timeout=5,local_infile=True)
cur = conn.cursor()
print ("Connected!\n")
for line in open('load.sql','r'):
    print(line)
    cur.execute(line)
conn.close()

Can anyone help?

Nivethitha Thiyagarajan · Accepted Answer · 2020-08-12 05:38:50Z

1

Pymysql doesnot support load command.

answered Aug 12, 2020 at 5:38

Nivethitha Thiyagarajan

1,3731 gold badge8 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

No error but load infile in .sql file not working in python script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related