General discussion

Locked

MySQL Error 1148: LOAD DATA LOCAL INFILE

By brandis ·
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 conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by BudTheGrey In reply to MySQL Error 1148: LOAD D ...

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

Collapse -

by brandis In reply to

Poster rated this answer.

Back to Networks Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums