Theodoros Emmanouilidis

Notes & Thoughts

MySQL ERROR 1148

February15

You get this error

1
ERROR 1148: The used command is not allowed with this MySQL version.

in your MySQL version while trying to issue a

1
LOAD DATA LOCAL INFILE

command?

For security reasons this command is no longer available by default.

In order to use it, just start a MySQL client issuing this command:

1
mysql --local-infile=1 -u root(or some user) -p

Now the command is available for the session.

posted under Tip Of The Day