Networks·41,398 discussions

MySQL Error 1148: LOAD DATA LOCAL INFILE

Locked

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?

Topic

Reply To: MySQL Error 1148: LOAD DATA LOCAL INFILE

In reply to MySQL Error 1148: LOAD DATA LOCAL INFILE

What version of the MySQL server are you running? The LOCAL keyword required version 3.22.6 or better. You can use the SQL command SELECT VERSION() to see what version your sever is running.

Of course, you can always download the latest version at http://www.mysql.org. I used MySQLFront for a while, but have switched to the MySQL Control Center. Purely a matter of prefrence, but I kinda like MySqlCC better.

hth

Reply To: MySQL Error 1148: LOAD DATA LOCAL INFILE

In reply to Reply To: MySQL Error 1148: LOAD DATA LOCAL INFILE

Poster rated this answer.

[Author]

Replies