Networks

Ask something
Discussion Locked

MySQL Error 1148: LOAD DATA LOCAL INFILE

0 helpful
2 replies

by brandis

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

2 replies

by budthegrey

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

This discussion is closed to new replies.