MySQL Error 1148: LOAD DATA LOCAL INFILE - TechRepublic
General discussion
October 2, 2003 at 02:49 PM
brandis

MySQL Error 1148: LOAD DATA LOCAL INFILE

by brandis . Updated 22 years, 9 months ago

Operating System: Windows 2000 Server
Database: MySQL
Database FrontEnd: MySQL-Front

I have a working database on my W2K Server using a MySQL database. The problem I’m having is importing either a .txt or .csv file into this database. I get the following error:

Error: 1148 – The used command is not allowed with this MySQL version

I have read many places that I need to enable….

“LOAD DATA LOCAL INFILE”

…and that’s where I’m stuck. How would I go about doing that? Which file(s) do I have to modify and which code(s) would I have to use?

This discussion is locked

All Comments