Forums

Programmatically LOAD DATA INFILE

Is there a way to have a script to LOAD DATA INFILE?

deleted-user-4271743 | 31 posts | Aug. 26, 2018, 9:57 a.m. | permalink

Hi- checkout how to do a restore on our help pages.

Staff conrad | 4232 posts | PythonAnywhere staff | Aug. 26, 2018, 10:59 a.m. | permalink

The link points to a DB restore. I was asking about a LOAD DATA LOCAL INFILE.

deleted-user-4271743 | 31 posts | Aug. 26, 2018, 1:24 p.m. | permalink

Oh sorry, I thought you wanted to load the file to restore the DB. Perhaps check out this forum discussion?

Staff conrad | 4232 posts | PythonAnywhere staff | Aug. 26, 2018, 5:31 p.m. | permalink

hmm... looks like we can specify the proper option in the connection statement. Haven't had the opportunity to test (had used a workaround for the task that had prompted me to ask this question) but worth giving it a try. (works locally)

db=MySQLdb.connect(passwd="pw",db="user$trackshunter",host='user.mysql.pythonanywhere-services.com',local_infile=1)
deleted-user-4271743 | 31 posts | Aug. 31, 2018, 9:21 p.m. | permalink