Hi, I've built a Django webapp that I'm trying to deploy. I have a MySQL db that I'm trying to populate with
LOAD DATA LOCAL INFILE...
to grab data from .csv files. This works locally, but on the server it gives the error:
django.db.utils.OperationalError: (1148, 'The used command is not allowed with this MySQL version')
I assume that this is because my local version of MySQL is different to PA's. Locally I've been using MySQL 5.7, but it seems PA runs MySQL 5.6.
So my question is, is there anyway to either use MySQL 5.7 on PA, or get the 'LOAD DATA LOCAL INFILE command working on on 5.6? I've seen solutions that involve editing the my.cnf file, but as far as I'm aware, you guys don't allow that.